Basic Data Descriptors, Statistical Distributions, and Application to Business Decisions | Online Course Support

Basic Data Descriptors and Data Distributions

ByAdmin September 8, 2021September 8, 2021

Week 1 >>> Basic Data Descriptors and Data Distributions >>> Basic Data Descriptors, Statistical Distributions, and Application to Business Decisions

Question 1

Download the file “OrderList.xlsx.” This file contains basic customer order information, including an order number, the region where the order was placed, the age of the customer, and the total dollar amount of the order.

Note: Please use a “.” instead of a “,” to indicate a decimal point.

The total number of orders in the “OrderList.xlsx” file is:

1 point

3000

————————————————————————————————–

2.81

————————————————————————————————–

120.27

————————————————————————————————–

The distribution is uniform.

The distribution is symmetric.

The distribution is skewed right.

The distribution is skewed left.

————————————————————————————————–

Question 6

Given the limited information you have, your boss wants you to group customers in a meaningful way. You decide to take a look at how the order region impacts things. Calculate the average total sales from the North region only. What is the difference between the North region average total sales and the average total sales across all regions (including the North)? Round to 2 decimal places.

[Note: To calculate the average total sales from the North region only you could either “sort” the data and calculate the average or “filter” the data, copy and paste as values and then calculate the average. Please refer to Course 1 of this specialization for details on sorting and filtering data]

1 point

1.44

————————————————————————————————–

Question 7

What is the absolute value of difference between the North region median total sales and all orders median total sales (across all regions including the North)?

Round your answer to two decimal places.

[Note: To calculate the median total sales from the North region only you could either “sort” the data and calculate the median or “filter” the data, copy and paste as values and then calculate the median. Please refer to Course 1 of this specialization for details on sorting and filtering data]

1 point

0.58

————————————————————————————————–

The distribution is uniform.

The distribution is normal.

The distribution is skewed right.

The distribution is skewed left.

————————————————————————————————–

We should separate customers by region and target the North region as our main customer segment. That segment has historically brought in higher average total sales.

We should separate customers by age group and target 21-30 as our main customer segment. That segment has historically brought in higher average total sales.

We should separate customers by age group and target 31-40 as our main customer segment. That segment has historically brought in higher average total sales.

We should separate customers by age group and target 41-50 as our main customer segment. That segment has historically brought in higher average total sales.

Country Level Economics: Policies, Institutions, and Macroeconomic Performance | Online Course Support

The PPP hypothesis implies that the real exchange rate must be equal to which of the following? Select all that apply.
ByAdmin August 31, 2021August 31, 2021

6. Question 6 The PPP hypothesis implies that the real exchange rate must be equal to which of the following? Select all that apply. 1 point eP/P*, where P…

Read More The PPP hypothesis implies that the real exchange rate must be equal to which of the following? Select all that apply.
Build personal resilience | Online Course Support

Rachel Lo is a busy executive at ABX Bank. As part of her duties, she is developing the specifications for a new HR system. There is a lot to do, it is a big project that is a bit overwhelming. Rachel has recognised individual tasks within this assignment and works daily on different smaller tasks.
ByAdmin September 19, 2021September 19, 2021

3. Question 3 Rachel Lo is a busy executive at ABX Bank. As part of her duties, she is developing the specifications for a new HR system. There is a…

Read More Rachel Lo is a busy executive at ABX Bank. As part of her duties, she is developing the specifications for a new HR system. There is a lot to do, it is a big project that is a bit overwhelming. Rachel has recognised individual tasks within this assignment and works daily on different smaller tasks.
Effective Business Presentations with Powerpoint | Online Course Support

We use body movement, position and proximity to others to communicate information such as attitude, and to control our environment.
ByAdmin September 2, 2021September 2, 2021

15. Question 15 We use body movement, position and proximity to others to communicate information such as attitude, and to control our environment. 1 point True False

Read More We use body movement, position and proximity to others to communicate information such as attitude, and to control our environment.
Online Course Support | Project Execution: Running the Project

What is project tracking?
ByAdmin September 1, 2021September 1, 2021

1. Question 1 What is project tracking? 1 / 1 point A method for responding to project risks. A method for assessing project successes and areas for improvement. A method…

Read More What is project tracking?
Construction Cost Estimating and Cost Control | Online Course Support

Considering the first question, what is the cost of the building in 2016 (Use cost capacity factor) ?
ByAdmin September 7, 2021September 7, 2021

2. Question 2 Considering the first question, what is the cost of the building in 2016 (Use cost capacity factor) ? 1 / 1 point $ 6,024,033 $ 4,776,000 $4,706,844…

Read More Considering the first question, what is the cost of the building in 2016 (Use cost capacity factor) ?
Food & Beverage Management | Online Course Support

Which of the following does mass market refer to?
ByAdmin September 11, 2021September 11, 2021

4. Question 4 Which of the following does mass market refer to? 1 / 1 point The market segment with the lowest product expectations The decision of the company to divide…

Read More Which of the following does mass market refer to?

Week 1 >>> Basic Data Descriptors and Data Distributions >>> Basic Data Descriptors, Statistical Distributions, and Application to Business Decisions

Similar Posts