# QNT 275 Weekly Practice Connect Knowledge Check and Apply Connect Weekly Case

Customized Service For QNT 275 Course
A+ Guaranteed!

QNT 275  2018 New

https://uopcourses.com/category/qnt-275/

https://uopcourses.com/math-course-help/

-------------------------------------------------------------------------------------
\$40 per week So you can use \$80 credit for two weeks' help.
-------------------------------------------------------------------------------------
\$40 For Week 1 Practice Connect Knowledge Check  and Apply Connect Case
\$40 For Week 2 Practice Connect Knowledge Check and Apply Connect Case
\$40 For Week 3 Practice Connect Knowledge Check and Apply Connect Case
\$40 For Week 4 Practice Connect Knowledge Check and Apply Connect Case
\$40 For Week 5 Practice Connect Knowledge Check and Apply Connect Case

------------------------------------------------------------------
Contact Info:    [email protected]
------------------------------------------------------------------

Apply: Connect Week 1 Exercise

Review the glossary in your textbook in preparation for this assignment.

Complete the Week 1 Exercise in Connect.

Note: You have only 1 attempt available to complete assignments.

Apply: Connect Week 2 Case

Part 1

You manage the inventory for a car dealership. Your management would like you to review current

inventory on the dealership lot.

Review the Week 2 Data Set.

Create and calculate the following in Excel®:

Create a Pie Chart which summarizes colors of the cars in the sample.

Create a Bar Chart which summarizes the frequency of the models of the cars in the sample.

Create a Frequency Table for classes of MPG, including Frequency and Relative Frequency for

the cars in the sample.

Calculate the mean Days in Inventory for the cars in the sample.

Compare that to the median and the mode.

Highlight the value that would be a better representation of the "typical" price of a car

in inventory?

Calculate the standard deviation of the Days in Inventory for the cars in the sample.

Calculate the 5 number summary for the suggested retail prices of the cars in the sample.

This consists of the 1st, 2nd, 3rd, 4th quartile and the IQR.

Note: Part 1 is not submitted. It is only to be completed in preparation for Part 2.

Part 2

Complete the Week 2 Case in Connect.

Note: You have only 1 attempt available to complete assignments.
Sample Car # Color MPG Suggest Retail Price Option Package Days in Inventory
1 Grey 27.6 \$24,390.00 LX 1
2 Grey 32.4 \$21,780.00 Touring 10
3 Blue 33.2 \$21,149.00 Touring 28
4 Black 34.7 \$22,069.00 LX 21
5 Blue 27.2 \$22,532.00 Touring 16
6 Blue 26.6 \$20,345.00 Touring 22
7 Red 37.3 \$22,112.00 EX 12
8 Silver 34.9 \$21,289.00 Touring 23
9 Silver 29.6 \$24,871.00 LX 15
10 Silver 32.3 \$25,389.00 EX 8
11 Grey 31.9 \$25,998.00 EX 28
12 Red 26.4 \$19,713.00 LX 55
13 Black 34.8 \$25,213.00 EX 2
14 Silver 35.9 \$24,467.00 Touring 33
15 Black 34.6 \$21,402.00 LX 17
16 Black 33.3 \$20,351.00 LX 14
17 Grey 33.1 \$23,732.00 Touring 1
18 Red 37.5 \$24,558.00 Touring 2
19 Red 27.8 \$19,167.00 LX 18
20 Red 36.1 \$19,903.00 Touring 22
21 Blue 28.8 \$22,140.00 Touring 19
22 Red 26.2 \$22,180.00 EX 41
23 Silver 27.4 \$23,120.00 Touring 33
24 Black 34.9 \$19,837.00 Touring 21
25 Red 36.5 \$24,666.00 EX 31
26 Red 26.3 \$19,446.00 EX 35
27 Blue 31.4 \$23,954.00 Touring 11
28 Blue 30.9 \$21,201.00 LX 3
29 Red 27.4 \$21,346.00 EX 26
30 Red 36 \$19,406.00 EX 31

Apply: Connect Week 3 Case

Part 1

Three hundred consumers between 21 and 49 years old were randomly selected. After sampling a
new wine cooler, each was asked to rate the appeal of the phrase: "Not sweet like wine coolers,
not filling like beer, and more refreshing than wine or mixed drinks" as it relates to the new
wine cooler. The rating was made on a scale from 1 to 5, with 5 representing "extremely
appealing" and with 1 representing "not at all appealing".

As a manager overseeing the development of the concept, you bottle the wine cooler and placed
it into distribution in one test store.

Your manager has asked you to assess the data and determine the most likely customer based on
the ratings. Additionally, your manager would like you to review sales in the test store.

Use the Week 3 Data Set to create and calculate the following in Excel®:

Estimate the probability that a randomly selected 21 to 49 year old consumer:

Would give the phrase a rating of 5

Would give the phrase a rating of 3 or higher

Is in the 21-24 age group

Is a male who gives the phrase a rating of 4

Is a 35 to 49 year old who gives the phrase a rating of 1

Based on the probabilities for the ratings of 4 and 5, which age/gender demographic

would be the best target audience for the new concept?

Create a probability distribution using the data which shows how many cartons of the wine

cooler were bought per customer in a month.

Calculate the mean and the standard deviation of your probability distribution.

Calculate the probability that exactly 3 six packs will be bought in a month.

Calculate the probability that between 4 and 8 six packs will be bought in a month.

Calculate the probability that at least 5 six packs will be bought in a month.

Calculate the probability that no more than 5 six packs will be bought in a month.

Create a relative frequency distribution based on the wine cooler drinking temperatures.

Create 6 bins with the same interval in each.

Create a histogram

Considering the mean and standard deviation for the ideal drinking temperature:

Calculate z values then refer to Table 6.1 - Cumulative Areas Under the Standard Normal

Curve

Calculate the probability of the wine cooler being less than 45 degrees.

Calculate the probability of the wine cooler being greater than 60 degrees.

Calculate the percentage of wine coolers served at the ideal temperature, between 49 and 55 degrees.

Part 2

Complete the Week 3 Case in Connect.

Note: You have only 1 attempt available to complete assignments.

RESULTS OF CONCEPT RATING FOR NEW WINE COOLER
Rating of the appeal of the phrase as it relates to the new wine cooler Total Sample Gender Age
Male Female 21 - 24 25 -34 35-49
Extremely appealing (5) 151 68 83 48 63 40
Somewhat appealing (4) 91 51 40 36 32 23
Neither appealing nor not appealing (3) 36 21 15 9 16 11
Somewhat unappealing (2) 13 7 6 4 6 3
Not at all appealing (1) 9 3 6 4 3 2

QUANTITY PURCHASED PER PERSON IN ONE MONTH
# of six packs purchased # people who purchased this amount
0 7
1 6
2 6
3 13
4 14
5 12
6 10
7 5
8 5
9 5
10 2

IDEAL TEMPERATURE
42
62
49
51
56
43
41
40
48
55
54
44
58
47
54
55
44
49
47
57
41
62
47
56
62
41
49
42
47
55

Apply: Connect Week 4 Case

Part 1

You manage Human Relations for your company. One of your sales managers has retired, leaving an
opening. You are considering two different employees for the position. Both are highly
qualified so you have decided to evaluate their sales performance for the past year.
Use the Week 4 Data Set to create and calculate the following in Excel®:
Determine the range of values in which you would expect to find the average weekly sales
for the entire sales force in your company 90% of the time.

Calculate the impact of increasing the confidence level to 95%?

Calculate the impact of increasing the sample size to 150, assuming the same mean and

standard deviation, but allowing the confidence level to remain at 90%?

Based on the calculated confidence interval for weekly sales on the sample of 50 reps at a
90% confidence level:
Calculate both Reps' average weekly performance and highlight if it is greater than the population mean.
You want to determine whether there is a statistically different average weekly sales
between Sales Rep A and Sales Rep B.

Create Null and Alternative Hypothesis statements that would allow you to determine
whether their sales performance is statistically different or not.
Use a significance level of .05 to conduct a t-test of independent samples to compare
the average weekly sales of the two candidates.
Calculate the p-value?
Considering that individual you did not promote:
Determine whether this person's average weekly sales are greater than the average
weekly sales for the 50 sales reps whose data you used to develop confidence intervals.
Create Null and Alternative Hypothesis statements that would allow you to determine
whether the new Sales Manager's weekly average sales are greater than the sample of Sales Reps.
Use a significance level of .05 to conduct a t-test of independent samples to compare
the average weekly sales of both.
Calculate the p-value?

Part 2

Complete the Week 4 Case in Connect.

Note: You have only 1 attempt available to complete assignments.

SAMPLE OF WEEKLY SALES
Sales Rep # AverageWeekly Sales(\$) Week # Weekly Sales(\$) - Rep A Weekly Sales(\$) - Rep B
1 1228 1 4657 5839
2 7374 2 6133 2602
3 1055 3 3438 2830
4 1859 4 7394 4763
5 3938 5 4327 3740
6 1692 6 2552 1315
7 569 7 7063 1599
8 4059 8 7844 1629
9 3689 9 6898 2416
10 607 10 4003 2107
11 1370 11 6884 4237
12 3735 12 4007 6322
13 3305 13 7214 2710
14 7228 14 2358 5890
15 6279 15 7745 5119
16 1671 16 1337 5184
17 5708 17 1052 3439
18 2569 18 6056 4828
19 4163 19 1495 3667
20 1519 20 3530 2518
21 7734 21 4749 6073
22 784 22 3833 5566
23 6766 23 7869 4555
24 7261 24 4541 5867
25 5034 25 6882 6039
26 7115 26 3868 1032
27 6291 27 5934 4834
28 6287 28 4447 3687
29 2080 29 5504 2214
30 7621 30 5554 4659
31 1047
32 6517
33 5172
34 3876
35 5429
36 4538
37 3786
38 2510
39 4863
40 7246
41 1175
42 641
43 4269
44 7034
45 3406
46 2256
47 3182
48 5178
49 4428
50 1189

Apply: Connect Week 5 Case

Part 1

You are the manager of a retail store. You want to investigate how metrics can improve the way

Use the Week 5 Data Set to create and calculate the following in Excel®:

Conduct a goodness of fit analysis which assesses orders of a specific item by size and

Conduct a hypothesis test with the objective of determining if there is a difference

between what you ordered and what you received at the .05 level of significance.

Identify the null and alternative hypotheses.

Generate a scatter plot, the correlation coefficient, and the linear equation that

evaluates whether a relationship exists between the number of times a customer visited the

store in the past 6 months and the total amount of money the customer spent.

Set up a hypothesis test to evaluate the strength of the relationship between the two

variables.

Use a level of significance of .05.

Use the regression line formula to forecast how much a customer might spend on merchandise

if that customer visited the store 13 times in a 6 month period. Consider the average monthly

sales of 2014, \$1310, as your base to:

Calculate indices for each month for the next two years.

Graph a time series plot.

In the Data Analysis Toolpak, use Excel's Exponential Smoothing option.

Apply a damping factor of .5, to your monthly sales data.

Create a new time series graph that compares the original and the revised monthly sales

data.

Part 2

Complete the Week 5 Case in Connect.

Note: You have only 1 attempt available to complete assignments.

ORDERS VS. SHIPMENTS
Extra Small 30 23
Small 50 54
Medium 85 92
Large 95 91
Extra Large 60 63
2X Large 45 42

CUSTOMERS IN PAST 6 MONTHS
Customer # # Visits \$ Purchases
1 8 468
2 6 384
3 8 463
4 2 189
5 10 542
6 4 299
7 6 345
8 2 197
9 4 293
10 1 119
11 3 211
12 9 479
13 7 430
14 7 404
15 6 359
16 10 544
17 9 522
18 5 327
19 6 353
20 7 405
21 4 289
22 7 386
23 7 403
24 1 146
25 7 416
26 9 485
27 3 333
28 7 241
29 2 391
30 6 268

MONTHLY SALES (\$)
Month \$ Sales
Jan 1375
Feb 1319
Mar 1222
Apr 1328
May 1493
Jun 1492
Jul 1489
Aug 1354
Sep 1530
Oct 1483
Nov 1450
Dec 1495
Jan 1545
Feb 1454
Mar 1322
Apr 1492
May 1678
Jun 1645
Jul 1580
Aug 1493
Sep 1719
Oct 1573
Nov 1629
Dec 1680

Week 1 Practice: Connect Knowledge Check

1.

Daily temperature in a local community collected over a 30-day time period is an example of cross-sectional data.

True

False

2.

Time series data are data collected at the same time period.

True

False

3.

Primary data are data collected by an individual.

True

False

4.

A random sample is selected so that every element in the population has the same chance of being included in the sample.

True

False

5.

__________ consists of a set of concepts and techniques that are used to describe populations and samples.

Data mining

Random sampling

Time series analysis

6.

A sequence of operations that takes inputs and turns them into outputs is a ____________.

statistical inference

process

random sampling

runs plot

7.

Processes produce outputs over time.

True

False

8.

Data mining

Descriptive analytics

Predictive analytics

Association learning

9.

The number of sick days taken by employees in 2008 for the top 10 technology companies is an example of time series data.

True

False

10.

A population is a set of existing units.

True

False

11.

A(n) _____________ variable is a qualitative variable such that there is no meaningful ordering or ranking of the categories.

interval

ordinal

ratio

nominative

12.

Judgment sampling occurs when a person who is extremely knowledgeable about the population under consideration selects the population element(s) that they feel is(are) most representative of the population.

True

False

Week 2 Practice: Connect Knowledge Check

1.

Award: 0.50 out of 0.50 points

In a statistics class, 10 scores were randomly selected with the following results: 74, 73, 77, 77, 71, 68, 65, 77, 67, 66.

What is the IQR?

11.00

10

5.00

5.25

12.00

2.

A quantity that measures the variation of a population or a sample relative to its mean is called the ____________.

range

interquartile range

standard deviation

coefficient of variation

variance

3.

Award: 0.50 out of 0.50 points

An observation separated from the rest of the data is a(n) ___________.

absolute extreme

outlier

quartile

mode

4.

Award: 0.50 out of 0.50 points

Quality control is an important issue at ACME Company, which manufactures light bulbs. To test the life-hours of their light bulbs, they randomly sampled nine light bulbs and measured how many hours they lasted: 378, 361, 350, 375, 200, 391, 375, 368, 321.

What is the mean?

375

389.9

368

346.6

200

5.

Award: 0.50 out of 0.50 points

In a statistics class, 10 scores were randomly selected with the following results (mean = 71.5): 74, 73, 77, 77, 71, 68, 65, 77, 67, 66.

What is the range?

516.20

144.00

22.72

4.77

12.00

6.

Award: 0.50 out of 0.50 points

Which percentile describes the first quartile, Q1?

25th

100th

75th

50th

7.

Award: 0.50 out of 0.50 points

Personnel managers usually want to know where a job applicant ranked in his or her graduating class. With a grade point average of 3.83, Michelle Robinson graduated above the 93rd percentile of her graduating class. What is the percentile rank of a student whose GPA was the median GPA.

75th

50th

25th

93rd

10th

8.

Award: 0.50 out of 0.50 pointS

All of the following are measures of central tendency except the ____________.

mode

range

mean

median

9.

Award: 0.50 out of 0.50 points

Quality control is an important issue at ACME Company, which manufactures light bulbs. To test the life-hours of their light bulbs, they randomly sampled nine light bulbs and measured how many hours they lasted (mean = 346.6).

378, 361, 350, 375, 200, 391, 375, 368, 321

What is the range?

58.5

191

3424.3

10,609

342.43

10.

The local amusement park was interested in the average wait time at their most popular roller coaster at the peak park time (2 p.m.). They selected 13 patrons and had them get in line between 2 and 3 p.m. Each was given a stopwatch to record the time they spent in line. The times recorded were as follows (in minutes): 118, 124, 108, 116, 99, 120, 148, 118, 119, 121, 45, 130, 118.

What is the mean?

115.5

148

118

114.15

45

11.

Award: 0.50 out of 0.50 points

The local amusement park was interested in the average wait time at their most popular roller coaster at the peak park time (2 p.m.). They selected 13 patrons and had them get in line between 2 and 3 p.m. Each was given a stopwatch to record the time they spent in line. The times recorded were as follows (in minutes): 118, 124, 108, 116, 99, 120, 148, 118, 119, 121, 45, 130, 118.

What is the median?

118

115.5

45

114.15

148

12.

Award: 0.50 out of 0.50 points

When establishing the classes for a frequency table, it is generally agreed that the more classes you use the better your frequency table will be.

True

False

Week 3 Practice: Connect Knowledge Check

Week 4 Practice: Connect Knowledge Check

Week 5 Practice: Connect Knowledge Check

…..

Practice: Week 1 Discussion Question 1

Consider a decision you need to make at work or at home.

Post your response in the discussion area.

Note: This must be original; do not use examples from the Internet.

Practice: Week 1 Discussion Question 2

Measures of Central Tendency

What are the different measures of central tendency?  When will they be used?

Practice: Week 2 Discussion Question 1

Objectives:

Research the Internet for an example of a pie chart or bar chart.

Post a copy along with its source in the discussion area.

Include a question regarding the chart for your classmates to respond to.

Respond to a classmate's question.

Practice: Week 2 Discussion Question 1

Objectives:

Research the Internet for an example of a pie chart or bar chart.

Post a copy along with its source in the discussion area.

Include a question regarding the chart for your classmates to respond to.

Respond to a classmate's question.

Practice: Week 3 Discussion Question 1

Objectives:

Reference the Week 2 Case.

Respond to one of the following:

Regarding requirement #4: What impact would an outlier have?

Regarding requirement #5: Why is it important to look at dispersion?  Why is standard deviation a better measure of dispersion than the range?

Post your response in the discussion area.

Practice: Week 3 Discussion Question 2

Objectives:

Variables

Differentiate between discrete and continuous variables?  Give examples of each?

Practice: Week 4 Discussion Question 1

Objectives:

Reference the Week 3 Case study.

Respond to one of the following:

Regarding requirement #2: What does the mean and standard deviation mean in terms of expected sales?

Regarding requirement #2: How can this information be used to benefit the business?

Regarding requirement #3: Can you conclude whether the data is normally distributed?

Regarding requirement #4: What can be interpreted by that percentage?

Post your response in the discussion area.

Practice: Week 4 Discussion Question 2

Objectives:

Normal Distribution

What are the characteristics of the normal distribution?

What are the applications of this distribution?

Practice: Week 5 Discussion Question 1

Objectives:

Reference the Week 4 Case study.

Respond to one of the following:

Regarding requirement #2: What impacted the Reps' average weekly performance to be greater than the population mean?

Regarding requirement #3: Considering your hypothesis statements, provide an example of a Type I and a Type II error.

Regarding requirement #3: Considering the p-values, is a statistically significant difference between the two reps being considered for the manager's position? Explain.

Regarding requirement #3: Who would you recommend to be promoted to Sales Manager - Rep A or Rep B?  Why?

Regarding requirement #4: Considering the outcome of the hypothesis test, is your new Sales Manager outperforming the sales force?

Post your response in the discussion area.

Practice: Week 5 Discussion Question 2

Objectives:

Hypothesis

How would you set up the null and the alternative hypothesis?

What are the rules you would follow here?