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.

Food & Beverage Management | Online Course Support

What is the distribution channel?
ByAdmin September 10, 2021September 11, 2021

7. Question 7 What is the distribution channel? 1 / 1 point A decision regarding how many steps there should be between the producers and the end-user A channel of suppliers…

Read More What is the distribution channel?
Online Course Support | Strategic Career Self-Management

Some examples of evidence included as a part of your ePortfolio may be (check all that apply):
ByAdmin September 11, 2021September 11, 2021

6. Question 6 Some examples of evidence included as a part of your ePortfolio may be (check all that apply): 1 point Media Writing samples Awards …

Read More Some examples of evidence included as a part of your ePortfolio may be (check all that apply):
Online Course Support | Strategic Planning and Execution

You’ve been tasked with securing a room for an upcoming strategic war room session. Which of the following spaces would be most effective?
ByAdmin September 16, 2021September 16, 2021

12. Question 12 You’ve been tasked with securing a room for an upcoming strategic war room session. Which of the following spaces would be most effective? 1 / 1 point A large,…

Read More You’ve been tasked with securing a room for an upcoming strategic war room session. Which of the following spaces would be most effective?
Entrepreneurship 4: Financing and Profitability | Online Course Support

If organizational synergies and faster resource acquisition are more important to you, you may want to consider ___.
ByAdmin August 17, 2021August 17, 2021

8. Question 8 If organizational synergies and faster resource acquisition are more important to you, you may want to consider ___. 1 point Private ownership Initial public offerings…

Read More If organizational synergies and faster resource acquisition are more important to you, you may want to consider ___.
Introduction to GIS Mapping | Online Course Support

In an attribute table, each vertical column is referred to as a:
ByAdmin August 21, 2021August 21, 2021

2. Question 2 In an attribute table, each vertical column is referred to as a: 1 point field record file geodatabase data model

Read More In an attribute table, each vertical column is referred to as a:
Bookkeeping Basics | Online Course Support

An accounting method in which revenues are reported when they are earned and expenses are reported when they are incurred is called:
ByAdmin August 7, 2021August 7, 2021

10. Question 10 An accounting method in which revenues are reported when they are earned and expenses are reported when they are incurred is called: 1 / 1 point Cash-Basis Accounting Accrual…

Read More An accounting method in which revenues are reported when they are earned and expenses are reported when they are incurred is called:

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

Similar Posts