you are curious about how many emails you send in a typical 5-day business week.
ID: 3158667 • Letter: Y
Question
you are curious about how many emails you send in a typical 5-day business week. you randomly select ten 5-day business weeks and count how many emails you send in each. The following table shows the hypothetical results for your sample:
120, 110, 118, 134, 136, 118, 131, 109, 129, 101
It is asking to do an excel showing average number of emails
EXAMPLE OF SPEEDSHEET
A B C
1. EMAILS SENT AVG # OF EMAILS
2. 120
3. 110
4. 118
5. 134
6. 136
7. 118
8. 131
9. 109
10. 129
11. 101
In cell C2 of the sample worksheet, select the formula to use to compute the average of your sample. Enter this same formula in your excel spreadsheet. The average of your sample is..... emails.
Options giving is 127.8, 117.0, 113.4, 120.6
OPTIONS TO SELECT FROM ARE BELOW
=MEAN(A2:A11
=AVERAGE (A2:A11
=MEAN(A2:A11)
=MEAN (B1:B11)
=MEAN (A1:A11)
=AVERAGE (B2:B11)
=AVERAGE (A1:A10)
Explanation / Answer
ANSWER: 120.6
=AVERAGE(A2:A11)--- IF THE DATA IS STARTING FROM 2nd row
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.