Statistics MBA Level -Urgent-
TopclasshomeworkAPLUS
part_d.docx
Part D: Must show all your work step by step in order to receive the full credit; Excel is not allowed. (39-50)
39. Use the given information to answer the following questions:
|
X |
0 |
1 |
|
f |
9 |
1 |
|
a. Range |
|
|
b. Variance |
|
|
c. Standard Deviation |
|
40. Financial planners often recommend international mutual funds to boost the overall performance of an investor's portfolio. The year's performance figures for U.S. stock funds and for international stock funds are as follows, in percentages.
|
Year |
U.S. Stock Funds |
International Stock Funds |
|
1983 |
21.77 |
27.73 |
|
1984 |
-1.20 |
-4.71 |
|
1985 |
28.52 |
44.44 |
|
1986 |
14.53 |
41.40 |
|
1987 |
1.17 |
7.02 |
|
1988 |
15.75 |
17.43 |
|
1989 |
25.09 |
21.98 |
|
1990 |
-6.11 |
-12.07 |
|
1991 |
36.67 |
12.51 |
|
1992 |
9.11 |
-4.48 |
|
1993 |
9.17 |
25.65 |
(Adapted from "International Aid," USA Today, October4, 1993, p.3B.)
Use the given information and fill in the table and answer the following question (a-b).
|
Year |
U.S. Stock Funds |
International Stock Funds |
||||||
|
|
X |
X2 |
|
|
X |
X2 |
|
|
|
1983 |
|
|
|
|
|
|
|
|
|
1984 |
|
|
|
|
|
|
|
|
|
1985 |
|
|
|
|
|
|
|
|
|
1986 |
|
|
|
|
|
|
|
|
|
1987 |
|
|
|
|
|
|
|
|
|
1988 |
|
|
|
|
|
|
|
|
|
1989 |
|
|
|
|
|
|
|
|
|
1990 |
|
|
|
|
|
|
|
|
|
1991 |
|
|
|
|
|
|
|
|
|
1992 |
|
|
|
|
|
|
|
|
|
1993 |
|
|
|
|
|
|
|
|
|
Total |
|
|
|
|
|
|
|
|
a) Answer the following questions.
|
Find:: |
U.S. Stock Funds |
International Stock Funds |
|
Mean |
|
|
|
Median |
|
|
|
Find:: |
U.S. Stock Funds |
International Stock Funds |
|
Range |
|
|
|
Variance |
|
|
|
S.D. |
|
|
b) Using part (a), describe to an investor the differences between the distributions of the performance figures for the two types of stock funds.
41. This frequency distribution represents the commission earned (in dollar) by 100 salespeople employed at several branches of a large chain store. ( Using D-Method)
|
Class |
Frequency |
CF |
Cumulative Relative Frequency |
Mid-point (X) |
d |
df |
d2 |
d2f |
|
150 – 158 |
|
|
0.05 |
|
-3 |
|
|
|
|
159 – 167 |
|
|
0.21 |
|
-2 |
|
|
|
|
168 – 176 |
|
|
0.41 |
|
-1 |
|
|
|
|
177 – 185 |
|
|
0.62 |
|
0 |
|
|
|
|
186 – 194 |
|
|
0.82 |
|
1 |
|
|
|
|
195 – 203 |
|
|
0.97 |
|
2 |
|
|
|
|
204 - 212 |
|
|
1.00 |
|
3 |
|
|
|
|
Total |
|
|
1.00 |
|
|
|
|
|
|
a) Mean
|
b) Median |
|
c) Mode
|
d) Range |
|
e) Variance
|
f) Standard deviation |
|
g) 3rd Quartile
|
42. Advertising expenditures constitute one of the important components of the cost of goods sold. From the following data giving the advertising expenditures (in millions of dollars) of 50 companies, approximate the mean, median, and standard deviation of advertising expenditure.
|
Advertising Expenditure |
Number of companies |
Cumulative Frequency |
Mid-point (X) |
d |
df |
d2 |
d2f |
|
25 and under 35 |
5 |
|
|
-2 |
|
|
|
|
35 and under 45 |
18 |
|
|
-1 |
|
|
|
|
45 and under 55 |
11 |
|
|
0 |
|
|
|
|
55 and under 65 |
6 |
|
|
1 |
|
|
|
|
65 and under 75 |
10 |
|
|
2 |
|
|
|
|
Total |
50 |
|
|
|
|
|
|
|
b) Mean
|
b. 50th Percentile |
|
c. Mode
|
d. Range |
|
e. Variance
|
f. Standard deviation |
|
g. 1rd Quartile
|
43. Work on problem 3 on page 3-49
44. Work on problem 4 on page 3-49(a-b)
|
a)
|
b) |
45. Use problem 1on page 4-9 to answer the following questions(a-h);
|
a) Find
|
b) Find |
|
c) Interpret the meaning of
|
d) Find the regression equation
|
|
e) Predict the case sales for a brand with a media expenditure of $80
|
f) Compute the coefficient of determination |
|
g) Interpret the coefficient of determination
|
h) Compute and interpret the coefficient of correlation
|
46. Fill in the blank and answer the following questions.
|
SUMMARY OUTPUT |
|
|
|
|
|
|
|
|
|
Regression Statistics |
|
|
|
|
|
|
|
|
|
Multiple R |
______ |
|
|
|
|
|
|
|
|
R Square |
______ |
|
|
|
|
|
|
|
|
Adjusted R Square |
0.8906 |
|
|
|
|
|
|
|
|
Standard Error |
13.8293 |
|
|
|
|
|
|
|
|
Observations |
______ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ANOVA |
|
|
|
|
|
|
|
|
|
|
df |
SS |
MS |
F |
Significance F |
|
|
|
|
Regression |
1 |
14200 |
14200 |
______ |
______ |
|
|
|
|
Residual |
8 |
______ |
191.25 |
|
|
|
|
|
|
Total |
9 |
15730 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
Lower 95.0% |
Upper 95.0% |
|
Intercept |
60 |
9.2260 |
6.5033 |
0.0002 |
______ |
81.2753 |
38.7247 |
______ |
|
X |
-5 |
0.5803 |
______ |
0.0003 |
______ |
6.3381 |
3.6619 |
______ |
|
a) What is
|
b) What is |
|
c) Interpret the meaning of
|
d) What is the regression equation
|
|
e) What is the coefficient of determination
|
f) What is the coefficient of correlation
|
|
g) Interpret the coefficient of determination
|
h) Interpret the coefficient of correlation
|
47. Please use the given printout and answer the following questions.
|
SUMMARY OUTPUT |
|
|
|
|
|
|
|
|
|
Regression Statistics |
|
|
|
|
|
|
|
|
|
Multiple R |
0.9630 |
|
|
|
|
|
|
|
|
R Square |
0.9274 |
|
|
|
|
|
|
|
|
Adjusted R Square |
0.9129 |
|
|
|
|
|
|
|
|
Standard Error |
1.5510 |
|
|
|
|
|
|
|
|
Observations |
7 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ANOVA |
|
|
|
|
|
|
|
|
|
|
df |
SS |
MS |
F |
Significance F |
|
|
|
|
Regression |
1 |
153.7199 |
153.7199 |
63.8974 |
0.0005 |
|
|
|
|
Residual |
5 |
12.0287 |
2.4057 |
|
|
|
|
|
|
Total |
6 |
165.7486 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Coefficients |
Standard Error |
t Stat |
P-value |
Lower 95% |
Upper 95% |
Lower 95.0% |
Upper 95.0% |
|
Intercept |
17.9276 |
10.1053 |
-1.7741 |
0.1362 |
-43.9042 |
8.0490 |
-43.9042 |
8.0490 |
|
Income Rate ($1000) |
-1.0946 |
0.1369 |
7.9936 |
0.0005 |
0.7426 |
1.4466 |
0.7426 |
1.4466 |
|
a) What is
|
b) What is |
|
c) Interpret the meaning of
|
d) What is the regression equation
|
|
e) What is the coefficient of determination
|
f) What is the coefficient of correlation
|
|
g) Interpret the coefficient of determination
|
h) Interpret the coefficient of correlation
|
48. Work on problem 5 on page 5-12 (a-c)
|
a)
|
b) |
|
c)
|
49. Work on problem 11 on page 5-13 (a-c)
|
a)
|
b) |
|
c)
|
50. Work on problem 33 on page 5-18(a-e)
|
a)
|
b) |
|
c)
|
d) |
|
e)
|
