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 A?

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.

❌
❌
✅
❌
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.
✅
❌
❌
❌
View this question

How many outliers are in the Sales Price chart shown below?

The box plot shows the sales price in dollars on the vertical axis ranging from $0 to $3,000 in increments of $500. The lower whisker shows a value of $19.00. The lower quartile shows a value of $59.00. The median shows a value of $149.00. The mean value shows X$625.40. The upper quartile shows a value of $949.00. The upper whisker shows a value of $1,799.00. The first outlier above shows a value of $2,299.00. The second outlier above shows a value of $2,599.00.

❌
❌
❌
✅
View this question

Based on the visualization, which state has higher sales revenue?

The map of the United States shows the sum of sales in the form of small and big spheres with 6 various amounts and colors along with the state names.

✅
❌
❌
❌
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. Below is a scatterplot showing advertising expense and sales revenue for the last 36 months. Based on the chart what type of correlation do advertising expense and sales revenue have?

The scatterplot shows a positive correlation between advertising expense and sales revenue. The x axis ranges from $5,600 to $6,200 in increments of 100 dollars. The vertical axis ranges from $0 to $180,000 in increments of $20,000. The data points are concentrated between ($5,700, $90,000) and ($6,150, $170,000).

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

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

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

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

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.

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