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!

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
What menu option/functionality in Excel creates a chart allowing data to be sliced, diced, filtered, conditionally formatted, and be modelled with sparklines?
❌
❌
✅
❌
View this question

A human resource survey asks employees to answer the question: How long is your commute from home to work? Employees are to select one of the following five choices.

0–2.0 miles

2.1–5.0 miles

5.1–10.0 miles

10.1–20 miles

More than 20 miles

This is an example of which type of data?

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