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 this scenario analysis in Lab 5.8 Excel: Applying Scenario Analysis: Trade War, what is the probability that domestic demand decreases income by 5% and there is a moderate trade war?

The table has 5 columns. Columns 3 to 5 are titled no trade war, moderate trade war and severe trade war. The values for moderate trade war across the 4 scenarios are as follow: Table 1: Income Scenarios: negative 10%; Domestic Demand Increases Income by 5%: 1,890,000; Domestic Demand Doesn't change: 1,800,000; Domestic Demand Decreases Income by 5%: 1,710,000. Table 2: Change in income based on scenario above. Income Scenarios: negative 10%; Domestic Demand Increases Income by 5%: (110,000); Domestic Demand Doesn't change: (200,000); Domestic Demand Decreases Income by 5%: (290,000). Table 3: probability of the scenario occurring Income Scenarios: negative 10%; Domestic Demand Increases Income by 5%: 0.20; Domestic Demand Doesn't change:0.15; Domestic Demand Decreases Income by 5%: 0.05. Sum: 0.40. Table 2: expected impact of changes in income due to trade war Income Scenarios: negative 10%; Domestic Demand Increases Income by 5%: (22,000); Domestic Demand Doesn't change: (30,000); Domestic Demand Decreases Income by 5%: (14,500); Sum of expected change in income: (66,500).

0%
0%
0%
0%
View this question

Based on these time series analysis results from Lab 5.3 Excel, Forecasting Product Demand using Time Series Analysis, what is the maximum amount of product demand that can be expected in 2026-12-01?

The columns headers are: month, monthly product demand, forecast (monthly product demand), lower confidence bound (monthly product demand), and upper confidence bound (monthly product demand). The entry for 2026-12-01 are as follow: monthly product demand, blank; forecast (monthly product demand), 308.99; lower confidence bound (monthly product demand), 292.45; upper confidence bound (monthly product demand), 325.53.

❌
❌
✅
❌
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. What is the slope of the line?

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

❌
❌
✅
❌
View this question

Identify the chart type for the exhibit below.

The figure shows a heat map titled profitability by region and business segment. The table contains 5 columns and 9 rows. The headings of columns 1 to 5 are as follows: region; return; consumer; corporate; home office. Column 1 contains the following from top to bottom: central; blank; east; blank; south; blank; west; blank. Column 2 contains the following from top to bottom: null; yes; null; yes; null; yes; null; yes. Rows 1 to 9 of columns 3 to 5 contain colors related to the following range: negative 4,485 to 42,641.

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

If we are running a regression to analyze the question if advertising expenses are related to sales revenue outcomes, what would be the independent variable?

❌
❌
❌
✅
View this question
A________ is the set of raw data that a chart visually represents. An example would be annual net income for the last ten years.
❌
✅
❌
❌
View this question
A human resource dashboard that allows managers to isolate an individual employee or like-aged employees to reveal average length of time with the company for the individual/group/department is said to be________.
✅
❌
❌
❌
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.

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

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