logo

Crowdly

Browser

Додати до Chrome

BU6015 - Business Analytics

Шукаєте відповіді та рішення тестів для BU6015 - Business Analytics? Перегляньте нашу велику колекцію перевірених відповідей для BU6015 - Business Analytics в moodle.polytechnic.bh.

Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!

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%
Переглянути це питання

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.

Переглянути це питання

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.

Переглянути це питання

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

Переглянути це питання

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.

Переглянути це питання

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%
Переглянути це питання

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.

Переглянути це питання
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%
Переглянути це питання

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.

Переглянути це питання

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%
Переглянути це питання

Хочете миттєвий доступ до всіх перевірених відповідей на moodle.polytechnic.bh?

Отримайте необмежений доступ до відповідей на екзаменаційні питання - встановіть розширення Crowdly зараз!

Browser

Додати до Chrome