ZuoTi.Pro
Question

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 Excel spreadsheet. Then enter your hypothetical results in cells A2 through A11. Your spreadsheet should look similar to the following sample spreadsheet: Emails Sent 120 110 118 134 136 118 131 109 129 101 Average Number of Emails: 10 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.

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 Average Number of Emails: 120.6 e3 Emails Sent 120 110 118 134 136 118 131 109 129 101 120.6 Average Number of Emails: 10 To calculate the average of all sample data from cell (A2:A11) enter following command into the cell C2 and then press enter. You will get the average of your sample data. -AVERAGE(A2:A11)

0 0
Add a comment
Know the answer?
Add Answer to:
5. Using Excel - Entering data and computing averages 5. Using Excel Entering data and computing...
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

  • 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....

  • 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:...

  • How do I plot a series graph with this data provided? Month 1987 1988 1989 1990...

    How do I plot a series graph with this data provided? Month 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 Jan 95 104 101 88 132 125 111 127 119 147 Feb 94 100 96 110 109 118 123 129 147 146 Mar 98 99 82 129 101 121 121 132 164 133 Apr 96 88 84 113 111 140 139 108 135 148 May 95 89 85 114 140 141 119 115 124 141 Jun 115 108...

  • (Use Excel) italy common for people to put on weight when they quit smoking While a...

    (Use Excel) italy common for people to put on weight when they quit smoking While a small weight gain is normal c e weight gain can create new health concerns that brode the benefits of not smoking. The accompanying table shows a portion of the weight data for 50 women before quitting and six months after quitting Use Table 2 Weight Before Quilling 140 144 138 Weight After Quilling 155 142 163 146 129 149 136 127 158 145 118...

  • Please answer the questions in yellow using an Excel Formula Answers must be written using an...

    Please answer the questions in yellow using an Excel Formula Answers must be written using an Excel Formula Thank You 4 111 A B D F G H 1 J K 107 Basic Functions 108 The AVERAGE function averages the cells that have numeric values. 109 Write a formula in the yellow cell immediately below that sets the value of cell equal to the average of the eight grey cells in the range F110:1111. 110 4 5 2 9 text...

  • Exercise 4.7: Using the data set in Exhibit 1.20, construct a single model for infant mortality...

    Exercise 4.7: Using the data set in Exhibit 1.20, construct a single model for infant mortality rate (IMR), using suitably defined indicator variables for rural-urban and male-female distinctions. Comb Rural Rural Urban Urban PQLI ined | Male Female Male Female Score IMR IMR IMR IMR IMR State 110 111 83 28 88 159 148 131 135 78 187 134 142 142 135 101 29 120 UTTAR PRAD. MADHYA PRAD. ORISSA RAJASTHAN GUJARAT ANDHRA PRAD HARYANA ASSAM PUNJAB TAMILNADU KARNATAKA MAHARASHTRA...

  • Using Excel - normal probabilities Consider the random variable x that follows a normal distribution, with...

    Using Excel - normal probabilities Consider the random variable x that follows a normal distribution, with a mean of μ = 54 and a standard deviation of σ = 4. You will select some of your answers to the questions that follow in this sample Excel spreadsheet: A B 1 P(x < 50.5) 2 P(49 < x < 51) In cell B1 of the sample spreadsheet, select the correct Excel formula for computing the probability that x is less than...

  • SCENARIO You are a Marriage and Family Therapist. In your practice, you’ve noticed that children seem...

    SCENARIO You are a Marriage and Family Therapist. In your practice, you’ve noticed that children seem to be dramatically influenced by their parent’s marital relationship. You think that changes in marital relationship can be predictive of a child’s overall life satisfaction. In order to test this, you collect data from both children and their parents (n=20). You give the children in your study the Child Psychological Wellbeing Inventory (CPWI) and their parents the Marital Satisfaction Survey (MSS). Using the data...

  • Maintaining a healthy weight is important for women’s health. Some physicians recommend being back to your...

    Maintaining a healthy weight is important for women’s health. Some physicians recommend being back to your pre-pregnancy weight six months after giving birth. Public health officials are interested in whether this is a realistic goal. Do the women in North Carolina weigh more than their pre-pregnancy weight six months postpartum? In other words, is the six months post-pregnancy weight greater than their pre-pregnancy weight? Use a paired samples t-test to compare pst6wght (variable 1) and prewght (variable 2). This uses...

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