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.

Online Course Support

Order the following probability distributions from lowest to highest entropy:
ByAdmin July 31, 2021

3. Question 3 Order the following probability distributions from lowest to highest entropy: A: (0.5, 0, 0, 0.5) B: (0.25, 0.25, 0.25, 0.25) C: (0, 0, 0, 1) D: (0.25,…

Read More Order the following probability distributions from lowest to highest entropy:
Finance for Managers | Online Course Support

Suppose that you are a bank manager and receive an application for a credit line of €100,000 from a small firm. What is the first thing you would look at?
ByAdmin September 10, 2021September 10, 2021

1. Question 1 Suppose that you are a bank manager and receive an application for a credit line of €100,000 from a small firm. What is the first thing you…

Read More Suppose that you are a bank manager and receive an application for a credit line of €100,000 from a small firm. What is the first thing you would look at?
Exploring and Producing Data for Business Decision Making | Online Course Support

x-bar (x̄), i.e., “standard error,” of a distribution is calculated by taking the population standard deviation and dividing it by the square root of 5 times n (where n is sample size).
ByAdmin August 31, 2021September 1, 2021

17. Question 17 x-bar (x̄), i.e., “standard error,” of a distribution is calculated by taking the population standard deviation and dividing it by the square root of 5 times n…

Read More x-bar (x̄), i.e., “standard error,” of a distribution is calculated by taking the population standard deviation and dividing it by the square root of 5 times n (where n is sample size).
Data Analytics for Lean Six Sigma | Online Course Support

CTQ: Productivity. Influence factor: Shift (morning, afternoon, night). You performed an equal variances test on the data from which the output is given. In the next step you want to study the difference in average productivity between the three shifts. To this end, which analysis should follow?
ByAdmin August 21, 2021August 21, 2021

10. Question 10 CTQ: Productivity. Influence factor: Shift (morning, afternoon, night). You performed an equal variances test on the data from which the output is given. In the next…

Read More CTQ: Productivity. Influence factor: Shift (morning, afternoon, night). You performed an equal variances test on the data from which the output is given. In the next step you want to study the difference in average productivity between the three shifts. To this end, which analysis should follow?
Foundations of Business Strategy | Online Course Support

A national grocery store chain with streamlined management and supplier efficiencies advertises the low cost of their products. Which competitive position are they occupying?
ByAdmin September 13, 2021September 14, 2021

2. Question 2 A national grocery store chain with streamlined management and supplier efficiencies advertises the low cost of their products. Which competitive position are they occupying? 1 / 1 point Focused…

Read More A national grocery store chain with streamlined management and supplier efficiencies advertises the low cost of their products. Which competitive position are they occupying?
Online Course Support | Understanding economic policymaking

Which of the following is NOT a true statement about structural policy or structural reform?
ByAdmin August 24, 2021August 24, 2021

3. Question 3 Which of the following is NOT a true statement about structural policy or structural reform? 1 point It rarely faces any opposition from special interest groups…

Read More Which of the following is NOT a true statement about structural policy or structural reform?

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

Similar Posts