QMB3250 Assignment 4 Statistics Using the two attachments, Please answer the questions listed in the word doc and reflect those answers on the excel spread

QMB3250 Assignment 4 Statistics Using the two attachments, Please answer the questions listed in the word doc and reflect those answers on the excel spreadsheet. Question 4 is not to be answered on the spreadsheet 39
71
79
85
90
48
71
79
86
91
55
73
79
86
92
63
74
80
88
92
66
76
80
88
93
68
76
82
88
95
68
76
83
88
96
69
77
83
89
97
70
78
83
89
97
71
79
85
89
99
61
95
85
87
92
69
77
74
83
76
81
84
75
80
78
83
yes
no
no
yes
no
no
yes
yes
no
yes
no
yes
yes
no
yes
yes
yes
no
yes
no
no
no
yes
yes
yes
no
yes
yes
yes
yes
yes
no
no
yes
yes
yes
no
yes
yes
yes
no
yes
yes
no
yes
no
yes
yes
yes
yes
QMB 3250
Assignment 04
1. Q 01 (15 Points):
The following data represent the scores of a sample of 50 randomly chosen students on a
standardized test.
39
71
79
85
90
48
71
79
86
91
55
73
79
86
92
63
74
80
88
92
66 68 68 69 70 71
76 76 76 77 78 79
80 82 83 83 83 85
88 88 88 89 89 89
93 95 96 97 97 99
Write a 95% confidence interval for the mean score of all students who took the test.
2. Q 02 (15 Points):
The following sample of 16 measurements was selected from a population that is
approximately normally distributed.
61
85
92
77
95
87
69
74
83
76
81
84
75
80
78
83
Construct a 90% confidence interval for the population mean.
3. Q 03 (15 Points):
A random sample of 50 employees of a large company was asked the question, “Do you
participate in the company’s stock purchase plan?” The answers are shown below.
yes no
no
yes
no
yes
yes no
no yes
no yes
yes yes
yes no
no yes
yes no
no no
no yes
yes yes
yes yes
yes yes
yes yes no no
no no yes yes
no yes yes yes
yes yes no yes
yes yes yes yes
Use a 90% confidence interval to estimate the proportion of employees who participate
in the company’s stock purchase plan.
4. Q 04 (15 Points):
Sales of a new line of athletic footwear are crucial to the success of a newly formed
company. The company wishes to estimate the average weekly sales of the new footwear
to within $350 with 90% reliability. The initial sales indicate that the standard deviation
of the weekly sales figures is approximately $1575.
How many weeks of data must be sampled for the company to get the information it
desires?

Purchase answer to see full
attachment