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!

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.

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

Based on these net present value calculations in Lab 5.7 Excel: Assessing the Returns to Education: To MBA or Not to MBA, at which age does the higher payoff begin for getting an MBA (as compared to not getting an MBA)?

The data in the table for getting an M B A. N P V: $756, 604.06. The data from age 25 to 60 across 2 column is as follows: 25, -$20,000.00, -$18,348.62 26, -$20.000.00,-$16,833.60 27, -$20,000.00, -$15,443.67 28, $75,000.00, $53,131.89 29, $77,250.00, $50.207.20 30, $79,567.50, $47,443.50 31, $81,954.53, $44,831.93 32, $84.413.16, $42364.12 33, $86,945.56, $40,032.15 34, $89,351.92, $37,828.54 35, $92,240.54, $35,746.44 36, $95,007.76, $33,778.36 37, $97,857.99, $31,919.19 38, $100,793.73, $30,162.17 39, $103,817.44, $28,501.46 40, $106,932.07, $26,932.95 41, $110,140.03, $25450.41 42, $113,444.23, $24,049.47 43, $116,847.56, $22,725.64 44, $120,352.98, $21,474.69 45, $123.963.57, $20,292.60 46, $127.682.48, $19,175.37 47, $131.512.95, $18,120.04 48, $135,458.34, $17.122.60 49, $139,522.09, 516,180.08 50, $143.707.76, $1428943 51, $148,018.99, $14,447.81 52, $152.459.56, $13,652.52 53, $157,033.34, $12,901.00 54, $161,744.35, $12,190.86 55, $166,596.68, $11,519.80 56, $171,594.58, $10,885.68 57, $176,742.41, $10,286.47 58, $182,044.69, $9,720.24 59, $187,506.03, $9,185.18 60, $193.131.21, $8,679.58 The data in the table for not getting an M B A. N P V: $583,923.03. The data from age 25 to 60 column is as follows: 25, $45,000.00 26, $45,900.00 27, $46,818.00 28, $47,754.36 29, $48,709.45 30, $49,683.64 31, $50,677.31 32, $51,690.86 33, $52,724.67 34, $53,779.17 35, $54,854.75 36, $55,951.84 37, $57,070.88 38, $58,212.30 39, $59,376.54 40, $60,564.08 41, $61,775.36 42, $63,010.86 43, $64,271.08 44, $65,556.50 45, $66,867.63 46, $68,204.99 47, $69,569.09 48, $70,960.47 49, $72,379.68 50, $73,827.27 51, $75,303.82 52, $76,809.89 53, $78,346.09 54, $79,913.01 55, $81,511.27 56, $83,141.50 57, $84,804.33 58, $86,500.41 59, $88,230.42 60, $89,995.03

100%
0%
0%
0%
View this question

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

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.

100%
0%
0%
0%
View this question

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

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