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 | Understanding Einstein: The Special Theory of Relativity

Why is the equating of Einstein’s theory of relativity with the philosophy of relativism an ironic misunderstanding?

ByAdmin July 28, 2021July 29, 2021

7. Question 7 Why is the equating of Einstein’s theory of relativity with the philosophy of relativism an ironic misunderstanding? 1 point Because in a fundamental way, relativity emphasizes…

Effective Business Presentations with Powerpoint | Online Course Support

What is the “Ribbon” in PowerPoint?

ByAdmin September 2, 2021September 2, 2021

1. Question 1 What is the “Ribbon” in PowerPoint? 1 point The Ribbon contains all PowerPoint functions and is a sub-tab of the “Insert” tab The Ribbon contains…

Build personal resilience | Online Course Support

Scenario: Alice Yu, as an employee of a large multi-national IT company, could see that the company’s processes were harming customers’ businesses and in the long term the IT company. Alice’s boss was happy for this to continue even after it had been brought to his attention many times as it did not affect his position. Alice told her boss that she had heard that a customer was going to sue for damages (although though this was a lie). Alice’s boss started to fix the problem immediately.

ByAdmin September 19, 2021September 19, 2021

5. Question 5 Scenario: Alice Yu, as an employee of a large multi-national IT company, could see that the company’s processes were harming customers’ businesses and in the long term…

Online Course Support | The Science of Success: What Researchers Know that You Should Know

In this module about the power of relationships, you learned that researchers who study social capital have found that:

ByAdmin August 7, 2021August 7, 2021

2. Question 2 In this module about the power of relationships, you learned that researchers who study social capital have found that: 1 point a. Newly arrived immigrants with…

Introduction to GIS Mapping | Online Course Support

Consider a World map that includes a Tissot’s Indicatrix, and that and in the image of a Tissot circle below are local longitudinal and latitudinal scale factors, respectively.

ByAdmin August 21, 2021August 21, 2021

5. Question 5 Consider a World map that includes a Tissot’s Indicatrix, and that and in the image of a Tissot circle below are local longitudinal and latitudinal scale factors,…

Inferential and Predictive Statistics for Business | Online Course Support

What is the t-value when testing the following hypotheses and sample data:

ByAdmin September 1, 2021September 1, 2021

8. Question 8 What is the t-value when testing the following hypotheses and sample data: H_{0}: μ = 180H0:μ=180 H_{a}: μ ≠ 180Ha:μ=180 α = 0.05, x̄ = 183.6, s…

Please Enable JavaScript in your Browser to Visit this Site.

#t42-content-protector-js-disabled { position: fixed; top: 0; left: 0; height: 100%; width: 100%; z-index: 999999; text-align: center; background-color: #FFFFFF; color: #000000; font-size: 40px; display: flex; align-items: center; justify-content: center; }

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

Similar Posts