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 this pivot table below, which customer number is the most profitable?

Row labels and sum of gross margin are the column heads of columns A and B, respectively, in row 3. The row entries in columns A and B are as follows: Row 4: 2047 and 357.70. Row 5: 2088 and 212.23. Row 6: 2072 and 139.01. Row 7: 2081 and 137.78. Row 8: 2100 and 135.47. Row 9: 2060 and 118.74. Row 10: 2064 and 115.33. Row 11: 2087 and 114.85. Row 12: 2046 and 114.29. Row 13: 2086 and 107.41. Row 14: 2024 and 104.78. Row 15: 2063 and 96.45. Row 16: 2031 and 81.81. Row 17: 2018 and 76.79. Row 18: 2051 and 69.83. Row 19: 2032 and 66.62. Row 20: 2021 and 64.64. Row 21: 2079 and 64.00. Row 22: 2099 and 58.56. Row 23: 2044 and 56.39. Row 24: 2041 and 47.22. Row 25: 2067 and 44.94. Row 26: 2048 and 41.12. Row 27: 2074 and 38.18. Row 28: 2068 and 36.62.

❌
❌
❌
✅
View this question

Based on Lab 2.4 Excel: Aggregating and Visualizing Different Data Types, given this key and this visualization, what does the slicer allow you to see?

The excel sheet shows the sales order quantity sold, a horizontal bar graph representing the data, and a list of states. The top left section of the excel sheet shows a table with 4 columns and 9 rows. The headings in columns 1 and 2 are as follows: sun of sales_order_quantity_sold; column labels. The heading in column 2 is selectable. The sub-headings in columns 1 to 4 are as follows: row labels; 2024; 2025; grand total. The row entries are as follows: row 3 - imperial stout; 92; 166; 258. Row 4 - I P A; 64; 183; 247. Row 5 - stout; 72; 118; 190. Row 6 - pale ale; 35; 81; 116. Row 7 - wheat; 33; 74; 107. Row 8 - imperial I P A; 19; 42; 61. Row 9 - grand total; 315; 664; 979. The horizontal bar graph on the right shows the data of the sum of sales order quantity sold with the following drop down menu selected: prodcut_description. On the right he years drop down menu is selected. Below is a list of the customer states with a vertical scroll bar on the right.

❌
✅
❌
❌
View this question

A correlation analysis was run in Excel to see how advertising expense was related to sales revenue. The output appears below.

The table contains 3 columns and 3 rows. The headings of columns 2 and 3 are as follows: advertising expense; sales revenue. The row entries are as follows: row 2 - advertising expense; 1; blank. Row 3 - sales revenue; 0.94383745; 1.

Which of the following statements are true?

  1. There is a weak relationship between advertising expense and sales revenue.
  2. There is a strong relationship between advertising expense and sales revenue.
  3. Advertising expense and sales revenue are positively related.
0%
0%
❌
0%
View this question

Identify the chart type for the exhibit below.

The figure shows a box plot. The vertical axis shows dollars ranging from $0 to $160 in increments of $20. The lower whisker has a value of $2.52. The first quartile has a value of $13.67. The median or the second quartile has a value of $30.77. Inside the box above the second quartile the following is entered: X$38.47. The third quartile has a value of $54.10. The upper whisker has a value of $109.52. The outlier above the upper whisker has a value of $120.52. The outlier and maximum value is $140.02.

❌
❌
❌
✅
View this question

Based on Lab 2.1 Excel: Identify and Work with Different Data Types, and the exhibit below, which of the following measures would not appear in the status bar (marked with the number 2 in the screenshot) when selecting the collection of dates marked with the number 1?

A table shows an excel sheet with 5 columns and 6 rows. The headings of columns 1 to 5 are as follows: sales_order_ID; sales_order_date; sales_employee_ID; customer_ID; sales_order_quantity_sold. The row entries are as follows: row 2 - 20001; 11 / 1 / 2024; 1006; 2056; blank. Row 3 - 20005; 11 / 1 / 2024; 1006; 2012; blank. Row 4 - 20017; 11 / 7 / 2024; 1006; 2043; blank. Row 5 - 20080; 11 / 29 / 2024; 1007; 2021; blank. Row 6 - 20140; 12 / 20 / 2024; 1006; 2002; blank. Rows 2 and 3 of column 2 are marked 1 and the bottom right of the status bar is marked 2.

0%
0%
0%
0%
View this question

Based on the data visualization, which state had the highest sales revenue?

The map of the United States shows the sum of sales with 6 various amounts and colors with names of states.

❌
❌
✅
❌
View this question

Based on the regression output generated in Lab 3.5 Excel, Deriving Cost Drivers for Activity-Based Costing (Regression Analysis), which of the following statements about the cost drivers for overhead cost per delivery is true? Assume alpha is set at 0.05.

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.89679396. Row 3 - R square; 0.80423941. Row 4 - adjusted R square; 0.79926245. Row 5 - standard error; 4.49411051. Row 6 - observations; 122. 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; 3; 9791.057335; 3263.685778; 161.5923672; 1.2764E-41. Row 3 - residual; 118; 2383.249459; 20.19702932; blank; blank. Row 4 - total; 121; 12174.30679; blank; blank; blank. The table below contains 7 columns and 5 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; 15.6744488; 2.968641478; 5.280007332; 5.96789E-07; 9.795730433; 21.55316711. Row 3 - miles per delivery; 0.45479993; 0.096881262; 4.694405458; 7.27182E-06; 0.262948651; 0.646651202. Row 4 - time per delivery; 1.88046082; 0.117656896; 15.98258056; 2.66501E-31; 1.64746813; 2.113453501. Row 5 - weight per delivery; -0.0022603; 0.002852916; -0.792275398; 0.429790028; -0.00790985; 0.003389256.

❌
❌
❌
✅
View this question

Based on these time series analysis results from Lab 5.5 Power BI, Forecasting Product Demand, estimate the amount of product demand in the final month forecasted.

The y axis plots monthly product demand and ranges from 200 to 350 and x axis plots years an ranges from 2021 to 2027. The graph shows an ocillating upward trend. It rises for the first 2 quarters falls in the third quarter and rises again in the fourth quarter. Tline begins at (2021, 210) and passes through (2024, 250), (2027, 310) and ends at about (2027, 300).

❌
❌
✅
❌
View this question

Based on the results of the ANOVA test conducted in Lab 3.4 Excel, Performing an ANOVA Test for Difference in Means to Determine If There Are Significant Differences Between the Average 4-Year Degree Completion Rate/SAT Average for Public, Private, and For-Profit Colleges, what would you conclude about the differences in the mean completion rates of the three types of colleges (public, private non-profit, and private for profit)? Assume that alpha is set at 0.05 and the alternative hypothesis is that the means are significantly different.

The table titled nova: single factor contains 2 tables. The table on the top contains 5 columns and 4 rows. The headings of columns 1 to 5 are as follows: groups; count; sum; average; variance. The row entries are as follows: row 2 - public; 668; 304.4049; 0.455695958; 0.032312755. Row 3 - private nonprofit; 1257; 682.7093; 0.543125935; 0.042450438. Row 4 - private for profit; 521; 198.6982; 0.381378503; 0.038350992. The table below titled Anova contains 7 columns and 5 rows. The headings of columns 1 to 7 are as follows: source of variation; S S; d f; M S; F; P-value; F crit. The row entries are as follows: row 2 - between groups; 10.4146521; 2; 5.207326049; 134.1747924; 0.000; 2.9994088. Row 3 - within groups; 94.81287291; 2443; 0.038810018; blank; blank; blank. Row 4 - blank; blank; blank; blank; blank; blank; blank. Row 5 - total; 105.227525; 2445; blank; blank; blank; blank.

✅
❌
❌
❌
View this question

What are the items in column S called?

The excel sheet contains a table of 8 columns and 8 rows. The heading in column 1 is as follows: total sales revenue. The heading in column 2 is selectable with the following menu selected: column labels. The sub-headings in columns 2 to 7 are as follows: 2018; 2019; 2020; 2021; 2022; grand total. The sub-heading in row 3 of column 1 is selectable where row labels is selected. The row entries are as follows: row 4 - deluxe; $85,950; $118,575; $173,250; $298,125; $334,125; $1,010,025. Row 5 - large; $153,900; $213,030; $294,165; $480,330; $598,050; $1,739,475. Row 6 - medium; $198,870; $296,940; $372,855; $656,460; $816,480; $2,341,605. Row 7 - small; $61,425; $81,375; $107,475; $181,350; $222,075; $653,700. Row 8 - grand total; $500,145; $709,920; $947,745; $1,616,265; $1,970,730; $5,744,805. The rows in the last column contain a line that starts from the bottom left and fluctuates and goes up and to the right and ends on the top right.

0%
0%
0%
0%
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

TelegramInstagramTikTokQuestion Bank
Terms of UseContact Us