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!

The following sales forecast was generated in Excel. What is line B?

A line graph shows month on the horizontal axis and the sales revenue in dollars in the vertical axis. The x axis ranges from 1 to 45 in increments of 2 units. The y axis ranges from $0 to $250,000 in increments of $50,000. A line starts from the left of the first quadrant at (1, $130,000) and fluctuates and goes to the right and ends on the right of the first quadrant at (37, $160,000). From the end of the line a small line marked A goes up and to the right and ends at (45, $195,000). Another line marked B comes down and then goes to the right and ends at (45, $150,000). Another line marked C comes steeply down and then goes slightly up and to the right ands ends at (45, $110,000). All values are estimated.

0%
0%
100%
0%
View this question

Identify the chart type for the exhibit below.

The bar graph shows the process time. The graph plots days versus number of orders. The y axis ranges from 0 to 9,000 in increments of 1,000 units. The bar marked 2, 7 has 7,600 number of orders. The bar marked 7, 12 has 8,300 number of orders. The bar marked 12, 17 has 2,300 number of orders. The bar marked 17, 22 has 400 number of orders. The bar marked 22, 27 has 900 number of orders. The bar marked 27, 32 has 400 number of orders.

0%
100%
0%
0%
View this question
Which of the following graphs would have a correlation coefficient equal to −0.87?
❌
✅
❌
❌
View this question

What is the minimum Sales Price 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

Based on this pivot table in Lab 1.2 Excel, Assessing Customer Profitability, 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

What is the 25th 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.

0%
0%
0%
0%
View this question

Based on this scenario analysis in Lab 5.8 Excel: Applying Scenario Analysis: Trade War, what is the probability that domestic demand decreases income by 5% and there is a moderate trade war?

The table has 5 columns. Columns 3 to 5 are titled no trade war, moderate trade war and severe trade war. The values for moderate trade war across the 4 scenarios are as follow: Table 1: Income Scenarios: negative 10%; Domestic Demand Increases Income by 5%: 1,890,000; Domestic Demand Doesn't change: 1,800,000; Domestic Demand Decreases Income by 5%: 1,710,000. Table 2: Change in income based on scenario above. Income Scenarios: negative 10%; Domestic Demand Increases Income by 5%: (110,000); Domestic Demand Doesn't change: (200,000); Domestic Demand Decreases Income by 5%: (290,000). Table 3: probability of the scenario occurring Income Scenarios: negative 10%; Domestic Demand Increases Income by 5%: 0.20; Domestic Demand Doesn't change:0.15; Domestic Demand Decreases Income by 5%: 0.05. Sum: 0.40. Table 2: expected impact of changes in income due to trade war Income Scenarios: negative 10%; Domestic Demand Increases Income by 5%: (22,000); Domestic Demand Doesn't change: (30,000); Domestic Demand Decreases Income by 5%: (14,500); Sum of expected change in income: (66,500).

0%
0%
0%
0%
View this question

Based on these time series analysis results from Lab 5.3 Excel, Forecasting Product Demand using Time Series Analysis, what is the maximum amount of product demand that can be expected in 2026-12-01?

The columns headers are: month, monthly product demand, forecast (monthly product demand), lower confidence bound (monthly product demand), and upper confidence bound (monthly product demand). The entry for 2026-12-01 are as follow: monthly product demand, blank; forecast (monthly product demand), 308.99; lower confidence bound (monthly product demand), 292.45; upper confidence bound (monthly product demand), 325.53.

❌
❌
✅
❌
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 figure shows a heat map titled profitability by region and business segment. The table contains 5 columns and 9 rows. The headings of columns 1 to 5 are as follows: region; return; consumer; corporate; home office. Column 1 contains the following from top to bottom: central; blank; east; blank; south; blank; west; blank. Column 2 contains the following from top to bottom: null; yes; null; yes; null; yes; null; yes. Rows 1 to 9 of columns 3 to 5 contain colors related to the following range: negative 4,485 to 42,641.

❌
❌
❌
✅
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