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.
We know that excel function to find the mean or average is AVERAGE(data range)
From question, data range = A2:A11
So, Average number of emails = AVERAGE(A2:A11)
and answer we get from the excel is AVERAGE(A2:A11) = 195.0
Hence, required function is AVERAGE(A2:A11) and average is 195.0
In cell C2 of the sample worksheet, select the formula to use to compute the average...
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 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...
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...
Serum Systolic Serum Systolic Serum Systolic Serum Systolic Serum Systolic 04 137 183115 218 145 209 170 195 115 Question 1a: Data a. Use the proportion from question 1a. Test the claim that the Sample 153 127 193 146 173 194 163 201...-174--157 proportion of Asianssi-s than 25%, use 219 ; 1191 163 160 174,160 140 Proportion 0.2 Critical Value 1.645 Margin of Error 0.0658 144 140 145 177 152166175 200 131 Hypotheses: You may write HO and Hl Test...
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...
On May 3, 2020, Leven Corp. negotiated a short-term loan of
$780,000. The loan is due October 1, 2020, and carries a 6.20%
interest rate. Use ordinary interest to calculate the interest.
What is the total amount Leven would pay on the maturity date? (Use
Days in a year table.) (Do not round intermediate calculations.
Round your answer to the nearest cent.)
TABLE 7-1 Exact days-in-a-year calendar (excluding leap year) 31 Day of month Dec. 31 Jan 1 2 3...
On May 3, 2020, Leven Corp. negotiated a short-term loan of
$900,000. The loan is due October 1, 2020, and carries a 7.00%
interest rate. Use ordinary interest to calculate the
interest.
What is the total amount Leven would pay on the maturity date? (Use
Days in a year table.) (Do not round intermediate
calculations. Round your answer to the nearest
cent.)
TABLE 7-1 Exact days-in-a-year calendar (excluding leap year) 31 Day of month Dec. 31 Jan 1 2 3...
Download the hypothesis testing dataset from the class website. 1. This is case 1, in which the value of population standard deviation is assumed to be known. a. Compute the standard deviation of the textbook price and assume this to be the population standard deviation. Type this value in E5. b. Pick a random sample of size 15. c. Compute the mean of your random sample in E4 using the AVERAGE function. d. Calculate the standard error in cell E9...
For an Independent t-test, you can either:
Perform all calculations by typing in formulas to compute the
needed components and answers
You can use the "Data: Data Analysis: t-test: Two Sample
Assuming Equal Variances" procedure
Examples of this procedure can be found in your text, Excel
Appendix 10.1, p. 459
For a Paired Differences t-test (dependent t-test), you can
either
Perform all calculations by typing in formulas to compute the
needed components and answer.
You can use the "Data: Data...
33 On May 6, Jim Ryan borrowed $14,000 from Lane Bank at 7 % interest. Jim plans to repay the loan on March 11. Assume the loan is on ordinary interest. How much will Jim repay on March 11? (Use Days in a year table) (Round your answer to the nearest cent.) Jm repay etbook 7-1 TABLE Exact days-in-a-year calendar (excluding leap year)" Day of month 30 31 30 31 28 31 30 31 31 30 31 31 Dec Mar...