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!

Identify the chart type for the exhibit below.

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

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

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

Which sort order would make the following bar chart the easiest to interpret?

The bar chart titled total sales by company contains company names on the x axis and total sales in dollars on the y axis. The bar for companies A and B shows a total sales of $35,000. The bar for company C shows a total sales of $36,000. The bar for company D shows a total sales of $27,000. The bar for company E shows a total sales of $36,000. All values are estimated.

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

What is the mean 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 above the second quartile the following is entered: 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 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%
100%
0%
View this question

Based on the summary statistics computed in Lab 4.1 Excel, Evaluating Inventory, Waste and Profit Margins, what is the average loss due to waste?

Statistics under inventory turnover are shown in columns A and B and that under waste as a percentage of costs are shown in columns C and D. The statistics under inventory turnover are shown in rows 3 to 15 under columns A and B, as follows: Mean: 5.661095515. Standard error: 0.45535057. Median: 4.467292249. Mode: not available. Standard deviation: 4.098335134. Sample variance: 16.79635087. Kurtosis: 3.488759241. Skewness: 1.775795275. Range: 20.79597681. Minimum: 1.280482453. Maximum: 22.07645926. Sum: 458.5487367. Count: 81. The statistics under waste as a percentage of costs are shown in rows 3 to 15 under columns C and D, as follows: Mean: 0.136110836. Standard error: 0.012282511. Median: 0.116705165. Mode: not available. Standard deviation: 0.110542603. Sample variance: 0.012219667. Kurtosis: 2.926831136. Skewness: 1.511460733. Range: 0.570726257. Minimum: 0.002081795. Maximum: 0.572808051. Sum: 11.02497774. Count: 81.

0%
0%
0%
100%
View this question

What menu option/functionality in Excel is suitable for the exhibit below?

The table contains 4 columns and 4 rows. The heading of column 1 is a drop down menu where row labels is selected. The headings of columns 2 to 4 are as follows: sum of transaction amount; average of transaction amount; count of transaction amount. The row entries are as follows: row 2 - in-person; $1,715.72; $33,64; 51. Row 3 - online; $5,709.24; $40.21; 142. Row 4 - grand total; $7,424.95; $38.47; 193.

✅
❌
❌
❌
View this question

What is the interquartile range (IQR) for 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 above the second quartile the following is entered: 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

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