ZuoTi.Pro
Question

you are curious about how many emails you send in a typical 5-day business week. you...

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)

math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

ANSWER: 120.6

=AVERAGE(A2:A11)--- IF THE DATA IS STARTING FROM 2nd row

0 0
Add a comment
Know the answer?
Add Answer to:
you are curious about how many emails you send in a typical 5-day business week. you...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 5. Using Excel - Entering data and computing averages 5. Using Excel Entering data and computing...

    5. Using Excel - Entering data and computing averages 5. Using Excel Entering data and computing averages 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 sent in each. The following table shows the hypothetical results for your sample 120 110 118 134 136 118 131 109 129 101 Enter a label (such as "Emails Sent") in cell A1 of an...

  • Using Excel - Entering data and computing average You are curious about how many emails you...

    Using Excel - Entering data and computing average You are curious about how many emails you receive in a typical day. You randomly select ten days and count how many emails you received in each. The following table shows the hypothetical results for your sample: Enter a label (such as "Emails Received") in cell A1 of an Excel spreadsheet. Then enter your hypothetical results in cells A2 through All. Your spreadsheet should look similar to the following sample spreadsheet: In...

  • In cell C2 of the sample worksheet, select the formula to use to compute the average...

    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. 6. Using Excel - Entering data and computing averages You are curious about how many emails you receive in a typical day. You randomly select ten days and count how many emails you received in each. The following table shows the hypothetical results for your sample:...

  • 3. + 0.5/3.5 points Previous Answers My Notes You must choose an SRS of 10 of...

    3. + 0.5/3.5 points Previous Answers My Notes You must choose an SRS of 10 of the 456 retail outlets in New York that sell your company's product. Question 1. How would you label this population? (Start at 001, not 000). 001 to 446 x Question 2. Use this random digits table, starting at line 122, to choose your sample. Which retail outlets would you select? (list the number labels of the outlets that you select in the order in...

  • data: (copy and paste in excel to view columns in alignment) Sample   Repair Time (days) 1  ...

    data: (copy and paste in excel to view columns in alignment) Sample   Repair Time (days) 1   12 2   17 3   9 4   16 5   10 6   18 7   12 8   14 9   15 10   14 11   14 12   8 13   11 14   10 15   8 16   8 17   14 18   12 19   14 20   13 21   12 22   15 23   15 24   10 25   24 26   17 27   13 28   15 29   13 30   15 31   36 32   40 33  ...

  • Dr. Brake teaches an introductory political science course at a small liberal art college in Ohio:...

    Dr. Brake teaches an introductory political science course at a small liberal art college in Ohio: Wittenberg University. Her class consists of 9 students, and she wants to send out a survey to her students in the middle of the semester to see how they are feeling about the course so far. The students in her course are listed below. Use the random digit table provided on eCampus to take a simple random sample of 5 students for Dr. Brake’s...

  • You are the manager of a company that owns several outpatient surgery facilities. You want to...

    You are the manager of a company that owns several outpatient surgery facilities. You want to determine if there are differences in overall patient health as measured by the General Health Status Score (GHSS) by type of patient carrier (Government, Insured, Uninsured). Your IT department provided you data on patient visits by type of carrier and the GHSS. Prepare a report to share with the owners of the facility that will help you make informed decisions about whether or not...

  • I have written my code for an employee management system that stores Employee class objects into...

    I have written my code for an employee management system that stores Employee class objects into a vector, I am getting no errors until I try and compile, I am getting the error: C2679 binary '==': no operator found which takes a right-hand operand of type 'const std::string' (or there is no acceptable conversion). But I am not sure why any help would be great, Thank you! 1 2 3 4 5 6 7 8 9 10 11 12 13...

  • I need help understanding what I need to do to complete this spreadsheet (steps on how...

    I need help understanding what I need to do to complete this spreadsheet (steps on how to start it) in Excel, thank you! Spreadsheet Assignment 2 Riesk and Return Historical Data NSTRUCTIONS listorical price data are obtained for Stocks X, Y, Z. To erform the required analysis, as demonstrated in the preadsheet modeling video, first calculate the rates f return for each stock. Then use the RETURNS data not price) to perform the required analysis. Please be ure to watch...

  • As you know from Project 4, McCormick & Company is considering building a new factory in...

    As you know from Project 4, McCormick & Company is considering building a new factory in Largo, Maryland. McCormick & Company decided to offer $4,424,000 to obtain the land for this project. The new factory will require an initial investment of $350 million to build the new plant and purchase equipment. You have been asked to continue your work from project 4 with a full analysis of the proposed factory, including the start-up costs, the projected net cash flows from...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT