logo

Crowdly

Browser

Add to Chrome

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!

Based on the summary statistics below, what is the IQR?

Average$ 38.47
Median$ 30.77
Skewness0.91
Kurtosis0.91
Maximum Value$ 140.02
Minimum Value$ 2.52
Standard Deviation29.14
Range$ 137.50
25th percentile (Quartile 1)$ 13.67 
75th percentile (Quartile 3)$ 54.10
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. Using the regression output, what is projected sales revenue if CoolIT spends $10,000 on advertising?

The excel sheet titled summary output contains 3 tables. The table at top contains 2 columns and 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.

0%
0%
0%
View this question

Identify the chart type for the exhibit below.

The box plot shows dollars on the vertical axis ranging from $0 to $160 in increments of $20. The lower whisker shows a value of $2.52. The lower quartile shows a value of $13.67. The median shows a value of $30.77. The mean value shows X$38.47. The upper quartile shows a value of $54.10. The upper whisker shows a value of $109.52. The first outlier above shows a value of $120.52. The second outlier above shows a value of $140.02.

View this question

A company wants to maximize sales. Based on the data visualization, which regions have the highest sales?

The tree map shows the region in columns and segment in rows with the sum of sales. Following is the sales by region and segment. Consumer: central - $252,031; east - $350,908; south - $195,581; west - $362,881. Corporate - central - $157,996; east - $200,409; south - $121,886; west - $225,855. Home office - central - $91,213; east - $127,464; south - $74,255; west - $136,722.

View this question

Which product has the highest percentage of sales revenue for the period?

A stacked bar chart shows the sales revenue for products A to E in percentage values. The y axis ranges from 0% to 100.00% in increments of 10%. The product A shows a sales revenue of 10.00%. The product B shows a sales revenue of 40%. The product C shows a sales revenue of 20%. The product D shows a sales revenue of 4%. The product E shows a sales revenue of 26%. All values are estimated.

0%
0%
0%
0%
View this question

Based on the below histogram, how many products are in the lowest bin?

In the histogram, the horizontal axis represents gross margin percentage (bin) ranging from 0.32 to 0.42 in increments of 0.02. The vertical axis represents count of gross margin percentage ranging from 0 to 26 in increments of 2. The data of the histogram are as follows: 0.32 to 0.35, 13. 0.35 to 0.38, 21. 0.38 to 0.40, 24. 0.40 to 0.42, 23. In the tabular data, S K U, description, and values are shown in three columns, as follows: F R T hyphen J A U, Jambul, and 0.42051. F R T hyphen P U E, purple mangosteen, and 0.41584. F R T hyphen J A B, Jabuticaba, and 0.41573. F R T hyphen P E A, pear, and 0.41530. F R T hyphen B I T, bilberty, and 0.41500. F R T hyphen M I I, miracle fruit, and 0.41463. F R T hyphen J A I, jackfruit, and 0.41270. F R T hyphen P L M, plumprune (dried plum), and 0.41221. F R T hyphen C H I, chico fruit, and 0.41143. F R T hyphen S A R, salal berry, and 0.41071. F R T hyphen A V D, avocado, and 0.41000. F R T hyphen B L N, blackcurrent, and 0.41000. F R T hyphen P L T, plumcot (or pluet), and 0.40952. F R T hyphen K I I, kiwifruit, and 0.40948. F R T hyphen G R I, graperaisin, and 0.40800. F R T hyphen L I M, lime, and 0.40625. F R T hyphen C U N, currant, and 0.40571. F R T hyphen P A Y, papaya, and 0.40566. F R T hyphen L O A, Longan, and 0.40541. F R T hyphen G U V, guava, and 0.40426. F R T hyphen P I L, pineapple, and 0.40260. F R T hyphen R E N, redcurrant, and 0.40141. F R T hyphen C U E, cucumber, and 0.40110.

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.

0%
0%
0%
View this question

Based on these regression results from Evaluating the Relationship Between Sales and R&D Expenditures: Testing for a Nonlinear Relationship, how can the relationship between sales and R&D be best explained?

Under regression statistics, the following values are shown: Multiple R, 0.909478. R square, 0.827151. Adjusted R square, 0.823859. Standard error, 6030121. Observations, 108. In the ANOVA table at the center, values are shown as follows: Regression: d f, 2. S S, 1.82709E + 16. M S, 9.14E + 15. F, 251.2333. Significance F, 9.49532E minus 41. Residual: d f, 105. S S, 3.81805E + 15. M S, 3.64E + 13. Total: d f, 107. S S, 2.20889E + 16 In the table at the bottom, the entries are shown as follows: Intercept: Coefficients, 21367225. Standard error, 2269617.303. t Stat, 9.414462. P value, 1.26E minus 15. Lower 95 percent, 16866993.19. R and D expenditures: Coefficients, 5.501598. Standard error, 1.980307943. t Stat, 2.778153. P value, 0.006477. Lower 95 percent, 1.575013356. R and D expenditures squared: Coefficients, 1.31E minus 06. Standard error. 3.89595E-07. t Stat, 3.351151. P value, 0.001119. Lower 95 percent, 5.33096E minus 07

View this question

Based on this visualization, which of the following customers are the most profitable?

The horizontal axis represents gross margin ranging from 0 to 360 in increments of 20 and the vertical axis shows the customer numbers. The graph decreases in gross margin from top to bottom. The data are shown as follows: 2047, 360. 2088, 220. 2072, 140. 2081, 138. 2100, 136. 2060, 119. 2064, 115. 2087, 114. 2046, 114. 2086, 107. 2024, 105. 2063, 96. 2031, 81. 2018, 77. 2051, 70. 2032, 66. 2025, 65. 2079, 64. 2099, 58. 2044, 56. 2041, 47. 2067, 45. 2048, 41. 2074, 38. 2068, 37. 2001, 35. 2066, 34. 2091, 30. 2006, 30. 2077, 25. 2055, 25. 2036, 25. 2084, 23. 2073, 22. 2038, 19. 2035, 10. 2098, 9. 2023, 5. All data are approximate.

View this question

What is being graphed in the chart?

The line chart shows the sales revenue with sales order month on the x axis and sales in amount of dollars in the y axis. The x axis ranges from May 2017 to November 2020 in increments of 6 months. The y axis ranges from $0 to $120,000 in increments of $10,000. The line passes by the following point at (May 2017, $30,000) and fluctuates and goes up and to the right and ends on the to right of the first quadrant at (November 2020, $90,000). All values are estimated.

View this question

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

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

Browser

Add to Chrome