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

ANo __________ hypothesis is a hypothesis used in hypothesis testing that is opposite of the null hypothesis, or a potential result that the analyst may expect.

❌
❌
✅
❌
View this question
The following chart presents the percentage of sales revenue generated by five different products for the current period. The company only sells these five items. What is the denominator when calculating the percentages?

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.

0%
0%
0%
0%
View this question

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