Description
An expert who works for a car magazine obtained random data (rounded to the nearest thousand) among two categories of used or new cars: Domestic ForeignThe expert would like to understand sales based on list price (rounded to the nearest thousand dollars), sale price (rounded to the nearest thousand dollars), and number of days it takes to sell each car. The complete data set is in the file named Cars.Managerial ReportPrepare a report (see below) that summarizes your assessment of the nature of the car market. Be sure to include the following seven items in your report.Calculate descriptive statistics (mean, median, range, standard deviation, and coefficient of variation) to summarize each of the three variables for the all Domestic cars.Use z-scores to determine if there any outliers in the data set for any of the three variables. If there are any outliers in any category, please list them and state for which category they are an outlier.If a result is an outlier, state whether it is below or above the mean.How can one use the above descriptive statistics to understand the Domestic car market better?Could there be any other descriptive statistics that can help one understand the Domestic car market better?Descriptive statistics (mean, median, range, standard deviation, and coefficient of variation) to summarize each of the three variables for the all Foreign cars.Use z-scores to determine if there any outliers in the data set for any of the three variables.If there are any outliers in any category, please list them and state for which category they are an outlier.If a result is an outlier, state whether it is below or above the mean.How can one use the above descriptive statistics to understand the Foreign car market better?Could there be any other descriptive statistic that can help one understand the Foreign car market better?Compare your summary results from #1 and #2. Discuss any specific statistical results that would help the car expert understand the two-car markets.Develop a 98% confidence interval estimate of the population mean sales price and population mean number of days to sell for Domestic cars. What is the margin of error?Interpret what each confidence intervals means. How can both confidence intervals provide useful car sales information?What other confidence interval would you choose to compute to obtain more information related to Domestic car sales? Explain why.What happens to the confidence interval as the level of confidence is increased?Develop a 98% confidence interval estimate of the population mean sales price and population mean number of days to sell for Foreign cars. What is the margin of error?Interpret what each confidence intervals means. How can both confidence intervals provide useful car sales information?What other confidence interval would you choose to compute to obtain more information related to Domestic car sales? Explain why.Assume the car expert requested estimates of the mean number of days to sell for the Domestic cars with a margin of error of seven days and the mean selling price of foreign cars with a margin of error of eight days.Using 98% confidence, how large should the sample sizes be for each one?How could the sample size formula be useful in understanding both types of car businesses? What are some advantages of a larger sample size?Suppose a Domestic car has a list price of $30,000 and a Foreign car has a list price of $30,000. What is your estimate of the final selling price (based on the percent difference for the sale and list price) and number of days required to sell each of these cars?How would these two estimates be useful in this application?Write a report that adheres to the formatting and APA expectations outlined on the CSU Global Writing Center (Links to an external site.). As with all written assignments at CSU Global, you should have in-text citations and a reference page.Submit your Excel file in addition to your report.Requirements:Paper must be written in third person.Your paper should be four to five pages in length (counting the title page and references page) and cite and integrate at least one credible outside source. The CSU Global Library (Links to an external site.) is a great place to find resources.Include a title page, introduction, body, conclusion, and a reference page.The introduction should describe or summarize the topic or problem. It might discuss the importance of the topic or how it affects you or society as a whole, or it might discuss or describe the unique terminology associated with the topic.The body of your paper should answer the questions posed in the problem. Explain how you approached and answered the question or solved the problem, and, for each question, show all steps involved. Be sure this is in paragraph format, not numbered answers like a homework assignment.The conclusion should summarize your thoughts about what you have determined from the data and your analysis, often with a broader personal or societal perspective in mind. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs.Include any tables of data or calculations, calculated values, and/or graphs associated with this problem in the body of your assignment.Document formatting, citations, and style should conform to the CSU Global Writing Center (Links to an external site.). A short summary containing much that you need to know about paper formatting, citations, and references is contained in the New Sample APA Paper (Links to an external site.). In addition, information in the CSU Global Library (Links to an external site.)has many helpful areas (Writing Center, Writing Tips, Template Examples/Papers Essays, and others).
1 attachmentsSlide 1 of 1attachment_1attachment_1
Unformatted Attachment Preview
Domestic Cars
List
Sale
Price in Price in Days to
K
K
Sell
Car
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
9
34
23.9
29.7
26.7
31.2
22.7
8
18.3
43.9
49.1
8.7
23.2
17.1
15.3
39.7
12.4
42.3
25
36.2
13.9
18.7
39.5
23
32
34.9
43.6
6.9
43.6
12
8.7
7.2
39.6
16.5
43.9
47.6
21.3
29.5
18.6
46.6
8
11.2
8.3
30.2
19.3
28.8
24.1
31.2
20.2
4
14.9
42.9
47.1
5.4
18.3
13.4
14.5
35.2
9.2
40.3
24.2
34.8
12.1
15.6
36.6
22.1
31
33.1
39.2
4.7
41.8
9.6
6.1
5.3
36
16.2
40.8
46.2
21
26.9
16.2
46
6.1
8.6
40
5
48
12
28
30
24
42
29
16
23
17
30
15
40
31
27
58
19
30
37
43
44
55
40
22
56
28
47
44
13
15
47
21
45
5
44
6
47
60
14
13
Foreign Cars
List
Sale
Price in Price in Days to
K
K
Sell
36.7
52
11.1
48.1
6.8
7.5
71.5
21.7
59.5
19.1
67
79.2
29.3
69.1
63.9
54.5
61.4
70.8
29.2
26.6
11.7
12.2
51.6
48.8
33.9
82.3
75.9
44.1
30.5
56.5
88.3
51.8
25.7
34.2
75.8
75.5
40
67
16
50.2
85.1
73
34.1
51.5
9.6
45.9
4.5
6.5
70.8
21.7
59.1
17.7
64.3
76.1
24.9
66
58.9
51.2
56.4
69.8
28.4
23.9
9
8.5
50.6
48.4
32.4
77.8
71.8
39.7
27.7
52.3
88
50.8
21.6
33.1
75.3
73.5
39.6
66.2
15
46.1
83.8
71.2
39
26
27
52
53
39
59
51
40
15
46
62
32
55
15
46
20
24
5
44
58
11
36
24
31
51
21
17
35
19
18
46
8
42
24
25
55
50
22
40
52
22
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
33.8
10.1
13.9
48.4
13.5
6.4
38.3
38.5
36.9
18.6
4.5
25.4
59.9
44
19.8
12.6
35
52.2
38.6
24
45
52.9
52.3
50.9
18.3
34.3
50.1
57.4
9.2
36.9
41.1
43.3
46.8
51.7
13.3
57.3
59.6
18.3
42.1
13.8
32.9
54
34.4
23.6
4.7
59
26.5
32.6
7.2
13.6
44.5
13.1
4.2
38.2
37.7
36.4
14.1
3.1
22.5
57.3
40.5
18.3
10.1
31.8
49.9
36.6
23.3
44.1
47.9
50.6
47.5
16.3
29.5
48.6
56.4
6.5
33.3
38.2
40.7
42.7
47
8.7
54.3
54.6
14.9
41
9.2
31.3
52.8
31.2
22.6
4
58.2
24.5
28
30
15
28
46
45
37
40
43
25
47
38
58
53
18
20
11
49
50
18
31
16
30
25
5
55
17
49
58
35
36
6
28
11
19
14
9
33
59
49
7
25
9
42
5
38
39
15
12.9
26.3
29.8
65.7
21.8
44.3
78.6
50
57.1
46.6
82.2
61.1
81
77.1
34.4
23
54.9
82.2
79
23.5
76.2
33
48.7
34
75.8
35.2
22.9
82.8
63.8
46.4
58.7
64
87.1
75
17
39.6
63.8
25.5
79.8
13.1
34.3
71.2
29.5
23.4
12.6
15.5
11.6
10.6
22
28.5
62.4
19.4
40.5
77.2
49.2
53.8
45.6
78.6
58.3
78.9
75.3
29.4
22.5
53.9
81.3
74.6
19.3
72.5
31.5
46.7
33.8
74
35
22.4
79.3
63.8
41.5
57.8
63.3
86.1
70.6
14.4
36.4
62.9
22.2
76.6
11.5
32.7
68.5
25.4
21.6
9.5
14
37
32
27
16
4
43
9
61
45
23
58
66
61
35
44
23
4
57
66
24
28
62
51
49
27
19
22
64
29
50
50
37
57
50
38
31
13
23
24
27
21
49
16
47
7
39
16
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
34.5
24.5
3.9
5
58.3
33.6
45.6
38.8
35.6
17
18
58.5
20.9
32.5
19
4.4
67.6
59.2
25
55.7
25.7
49.1
67.7
45
48.6
25.9
37.8
25.7
27.3
65
58.3
8.6
40
3.9
21.2
36
36.2
67.4
24
10
36.4
38.4
32.7
11.9
8.7
13.5
18.3
30.8
20.5
1.9
4.8
58.1
32.1
42.7
34.9
34.2
12
15.5
55.4
19.9
32.1
14.4
4
67.4
54.3
21.7
52.8
23.9
44.7
66.3
41
43.6
25.7
37
20.8
24.8
64.2
56.9
4.6
37
3
19.3
35.1
33.8
66.3
21
8.8
36.4
37.5
28
11
5.5
10.5
14.8
48
56
34
31
30
18
9
18
47
28
51
50
48
6
35
27
39
57
25
62
62
29
28
65
63
55
50
31
51
30
57
62
33
20
54
23
51
17
19
49
11
46
44
11
17
33
12
60
20.9
81.8
89
38.1
15.5
60.3
64.2
52.2
4.9
41.3
64.6
49.6
46.4
51.8
78.8
55.2
21
32.5
43.5
11.9
15.1
50.1
81.2
83.8
68
54.4
54.5
4.9
30.7
45
20.4
24
79.1
22.8
66
88.1
8.6
38.3
52.1
23.7
67.1
63.4
45.9
77.3
46.5
63.9
59.4
17.1
79.8
84.1
35
12.7
58.4
63.1
49.5
3.3
41.2
63.5
45.6
42.4
49
77.6
54.7
17.3
30.5
43
9.5
10.4
48.7
79.7
79.1
65.1
50.8
51.4
1.3
29
40.4
17.4
23.9
78.4
18.2
65.8
85.6
3.8
35.1
49.1
20.7
63.3
61.3
41
74.4
42.6
60
4
12
45
56
39
51
21
8
18
26
18
19
47
41
54
60
21
43
67
3
65
14
45
36
35
28
14
12
57
50
60
11
5
53
31
24
31
60
60
49
6
38
33
10
25
27
56
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
3.8
67.3
24.7
29
12.4
26.4
24.2
59
18.7
29.6
46.9
59.9
38.7
35.7
34.4
32
22.8
16.9
9
63.8
10.2
52.8
42.1
9.6
17.8
48
67.3
29
13.9
18.2
54.9
78.8
10.5
21.7
7.9
25.1
22.4
62.8
73.1
21.1
50.8
18.5
41
56.9
60.5
56.9
20
3
65.3
22.2
29
11.4
21.9
19.2
55
16.7
28.4
46.5
57.7
35.6
32.2
33.6
27.1
18.1
16.2
4.2
59.4
5.3
51.8
39.6
7.2
14.2
46.3
63
25
11.3
16.1
53.5
76.5
8.4
17.8
7.1
23.8
17.5
58.3
68.3
20.7
46.4
18.4
36.7
53.6
60.3
55.1
17
37
53
53
16
54
8
70
60
40
37
69
10
33
45
60
43
43
56
28
46
54
48
22
58
59
30
11
65
49
35
67
67
17
24
29
34
23
18
8
18
41
43
11
50
13
42
13
83.2
5.4
9
78.2
27.3
67
84.1
77.7
51.7
79
50
30.5
49.8
59.8
17.4
32.1
41.1
54.1
13.6
43
85.8
35.6
25
8.8
41.8
20.4
60.3
68
65
11.3
37.5
88.3
62.8
71.8
86.5
71.8
47.1
89.3
75
69.6
87.4
24.7
73.9
80.6
89.1
55
24.7
81.3
1.7
6.4
74.2
25.3
62.8
82.1
73.9
51.4
74.5
46.1
29.7
49.7
59.1
15.7
31.2
38.1
53.1
10.8
39.3
82.9
32.6
22.7
4.4
39.5
19.4
59
64.5
61.3
9
32.9
87.7
58.2
69.2
84.6
67.3
45.2
85.7
70.1
66.8
83.5
22.6
72.6
79.1
87
54.3
22.4
62
55
61
66
3
14
44
15
38
33
10
29
47
17
67
54
54
59
62
45
56
53
9
50
26
23
22
68
66
4
22
30
28
59
53
46
65
11
28
11
16
15
14
15
56
71
57
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
19.5
25.5
50.4
73.1
18.5
71.3
69
60.8
19.7
21.9
9.4
34.9
21.9
27.4
14.3
5.2
14.3
18.2
20.9
50
70.8
15.7
66.4
66.9
57.8
18.7
19
8.6
32.6
21.3
23.3
11.7
3.8
10.9
5
53
15
41
54
4
26
15
13
1
2
5
13
12
1
3
7
4.8
84.2
86.9
85.7
40.8
57.2
6.5
79.1
14.6
1.1
5
8
27
14.8
54.4
89.5
11.5
2.3
81.8
83.5
81
38.9
53.5
5.5
76.1
12.2
0.8
4
4.9
22
11.9
53.6
87.1
7.6
39
14
19
39
51
56
41
29
1
2
14
30
18
11
15
100
14
Purchase answer to see full
attachment
Tags:
standard deviation
descriptive statistics
Coefficient of Variation
Domestic and Foreign cars
Domestic Cars data
User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.
Reviews, comments, and love from our customers and community: