logo

Crowdly

BU6015 - Business Analytics

Looking for BU6015 - Business Analytics test answers and solutions? Browse our comprehensive collection of verified answers for BU6015 - Business Analytics at moodle.polytechnic.bh.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

Which type of analytics will forecast product demand?

View this question

A new business, CoolIT, sells items to keep you cool when outside. Its products include coolers, generators, floats, and other water accessories designed to beat the heat. CoolIT has been spending money on innovative advertising in hopes of increasing its sales revenue. A CoolIT business analyst ran a regression using 36 months of data using the Excel Data Analysis Toolpak. The output is shown below. What is the slope of the line?

The excel sheet titled summary output contains 3 tables. The table at top contains 2 columns and 6 rows with the following sub-title: regression statistics. The row entries are as follows: row 2 - multiple R; 0.95011488. Row 3 - R square; 0.90271829. Row 4 - adjusted R square; 0.89985706. Row 5 - standard error; 6748.44918. Row 6 - observations; 36. The table below titled Anova contains 6 columns and 4 rows. The headings of columns 2 to 6 are as follows: d f; S S; M S; F; significance F. The row entries are as follows: row 2 - regression; 1; 14368384267; 1.44E+10; 315.5004; 8,92218E-19. Row 3 - residual; 34; 1548413256; 45541566; blank; blank. Row 4 - total; 35; 15916797524; blank; blank; blank. The table below contains 7 columns and 3 rows. The headings of columns 2 to 7 are as follows: coefficients; standard error; t stat; P-value; lower 95%; upper 95%. The row entries are as follows: row 2 - intercept; -836512.83; 54148.06535; -15.4486; 6.16E-17; -946554.9386; -726470.7216. Row 3 - advertising expense; 163.271654; 9.192016768; 17.76233; 8.92R-19; 144.5912287; 181.9520799.

View this question

Identify the chart type for the exhibit below.

The map of the United States shows the sum of sales in the form of small and big spheres with 6 various amounts and colors.

View this question

Based on these regression results from Lab 5.6 Excel: Forecasting Product Demand Using Regression, which independent variables are significantly related to forecast demand?

Under regression statistics, the following values are shown: Multiple R, 0.891401552. R square, 0.794596727. Adjusted R square, 0.780591959. Standard error, 4.286745807. Observations, 48. In the ANOVA table at the center, values are shown as follows: Regression: d f, 3. S S, 3127.861777. M S, 1042.621. F, 56.73758. Significance F, 3.6376E minus 15. Residual: d f, 44. S S, 808.5523431. M S, 18.37619. Total: d f, 47. S S, 3936.41412. In the table at the bottom, the entries are shown as follows: Intercept: Coefficients, negative 123.7576339. Standard error, 22.11431598. t Stat, negative 5.59627. P value, 1.32E minus 06. Lower 95 percent, negative 168.3261093. G D P: Coefficients, 2.162221318. Standard error, 0.212246208. t Stat, 10.18733. P value, 3.76E minus 13. Lower 95 percent, 1.734467193. Weather (average Fahrenheit): Coefficients, 0.202019743. Standard error. 0.043196935. t Stat, 4.676715. P value, 2.78E minus 05. Lower 95 percent, 0.114962041. Holiday: Coefficients, 7.513785459. Standard error. 1.745077976. t Stat, 4.305702. P value, 9.17E minus 05. Lower 95 percent, 3.99681189.

View this question

________ explains the extent to which a data item gains or loses magnitude or value.

View this question

Based on this pivot table in Lab 1.3 Excel, Assessing Product (SKU) Profitability, which product number is the most profitable per dollar of sales?

S K U, description, sales price per pound, cost per pound, gross margin, and gross margin percentage are the column heads of the pivot table with dropdown buttons. The row entries are as follows: F R T hyphen S A R, salal berry, 1.12, 0.66, 0.46, and 0.411. F R T hyphen R E N, redcurrant, 1.42, 0.85, 0.57, and 0.401. F R T hyphen A V D, avocado, 1, 0.59, 0.41, and 0.410. F R T hyphen P U E, purple mangos, 1.01, 0.59, 0.42, and 0.416. F R T hyphen B I T, bilberty, 2, 1.17, 0.83, and 0.415. F R T hyphen P L T, plumcot, 2.1, 1.24, 0.86, and 0.410. F R T hyphen B L N, blackcurrent, 2, 1.18, 0.82, and 0.410. F R T hyphen P I L, pineapple, 0.77, 0.46, 0.31, and 0.403. F R T hyphen P L M, plumprune, 1.31, 0.77, 0.54, and 0.412. F R T hyphen C U N, currant, 1.75, 1.04, 0.71, and 0.406. F R T hyphen P E A, pear, 1.83, 1.07, 0.76, and 0.415. F R T hyphen P A Y, papaya, 1.06, 0.63, 0.43, and 0.406. F R T hyphen C H I, chico fruit, 1.75, 1.03, 0.72, and 0.411. F R T hyphen M I I, miracle fruit, 2.05, 1.2, 0.85, and 0.415. F R T hyphen L O A, Longan, 1.85, 1.1, 0.75, and 0.405. F R T hyphen L I M, lime, 0.96, 0.57, 0.39, and 0.406. F R T hyphen C U E, cucumber, 1.82, 1.09, 0.73, and 0.401. F R T hyphen K I I, kiwifruit, 2.32, 1.37, 0.95, and 0.409. F R T hyphen J A U, jambul, 1.95, 1.13, 0.82, and 0.421. F R T hyphen J A I, jackfruit, 0.63, 0.37, 0.26, and 0.413. F R T hyphen J A B, jabuticaba, 0.89, 0.52, 0.37, and 0.416. F R T hyphen G U V, guava, 0.94, 0.56, 0.38, and 0.404. F R T hyphen G R I, graperaisin, 1.25, 0.74, 0.51, and 0.408.

View this question

What is the 50th percentile in the chart shown below?

The figure shows a box plot. The vertical axis shows the sales price ranging from $0 to $3,000 in increments of $500. The lower whisker has a value of $19.00. The first quartile has a value of $59.00. The median or the second quartile has a value of $149.00. Inside the box the mean value is X$624.40. The third quartile has a value of $949.00. The upper whisker has a value of $1,799.00. The outlier above the upper whisker has a value of $2,299.00. The outlier and maximum value is $2,599.00.

View this question

A diagram showing interrelationships between two or more variables is called a ________.

View this question
The type of flavour of ice cream that people prefer is an example of which of the following terms?
View this question

Diagnostic analytics is performed to investigate the underlying reasons for past results that cannot be answered by simply looking at the descriptive data.

View this question

Want instant access to all verified answers on moodle.polytechnic.bh?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!