1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Ann [662]
3 years ago
14

Weights, in pounds, of ten-year-old girls are collected from a neighborhood. A sample of 26 is given below. Assuming normality,

use Excel to find the 98% confidence interval for the population mean weight μ. Round your answers to three decimal places and use increasing order.
66.4
86.3
71.3
52.8
68.0
85.0
66.2
79.2
93.5
84.5
71.1
74.5
65.0
58.5
59.8
80.2
69.2
92.9
78.9
59.4
63.6
66.5
60.7
80.1
60.4
74.5
Mathematics
1 answer:
tino4ka555 [31]3 years ago
7 0

Answer:

The 98% confidence interval for the sample mean is (66.763, 76.969).

Step-by-step explanation:

The main difficulty of this problem is to write all the data into an Excel sheet. Once we have done this part the problem is not difficult. Here we are assuming that we do not know the standard deviation. Also, we need to remark that the data has been written from the cell A1 to the cell A26.

<em>First step</em>: Let us calculate the mean of the sample. This can be done using an Excel function: AVERAGE. If we want to write the mean in the cell B1, we mark the cell and then write =AVERAGE(A1:A26). Notice that the arguments of the function is the first and the last cell of our data. With this we get that μ = 71.86538462 , and rounding μ = 71.866.

<em>Second step</em>: Now we need to calculate the standard deviation of the sample, because we do not know the theoretical standard deviation. This can be done using an Excel function: STDEV. If we want to write the mean in the cell B2, we mark the cell and then write =STDEV(A1:A26).  Notice that the arguments of the function is the first and the last cell of our data. With this we get that σ = 11.0160226 and rounding σ = 11.016.

<em>Third step: </em>We are going to calculate the confidence. This can be done using an Excel function: CONFIDENCE. If we want to write the mean in the cell B3, we mark the cell and then write =CONFIDENCE(0.02;11.016;26). Let us explain what are the arguments of the function CONFIDENCE:

  • The number 0.02 is the level of confidence. Notice that in the statement of the problem we were asked to find ‘‘the 98% confidence interval’’, but Excel can not understand this data, so we need to ‘‘normalize’’ it using the formula 1 - 98/100 = 1-0.98=0.02.
  • The second number, 11.016, is the standard deviation obtained in the second step.
  • The 26 is the number of samples we have.

With this we get that the confidence is  ε=5,10298125 , and rounding is ε=5,103.

<em>Fourth step</em>: Finally we are going to find the confidence interval. Here we are going to use the results of the first and third step. The confidence interval is obtained by the formula (μ - ε, μ + ε). Then,

(μ - ε, μ + ε) = (71.866 - 5,103, 71.866 + 5,103) = (66.763, 76.969)

You might be interested in
The original price of a mountain bike was reduced by $125. If p = the mountain bike's original price in dollars, which algebraic
Damm [24]
P-125 is the answer i believe you are looking for. Since p is the original amount of the mountain bike, and the question says the price was reduced by $125, this means that $125 was subtracted from p, the original price. Therefore, p-125.
8 0
3 years ago
A triangle can exist with side lengths 15cm, 22cm, and 35cm.<br> A<br> False<br> B<br> True
Advocard [28]

Answer:

The answer is False maybe

8 0
3 years ago
Please help i’m sorry!!! 15 points again!
morpeh [17]

Answer:

Guess I'll agree with the other person.

Step-by-step explanation:

7 0
2 years ago
The manager at a supermarket arranged 10 rows of cans. He put 2 cans in the first row, 4 cans in the second row, and 6 cans in t
Elena-2011 [213]
A)

2, 4, 6, 8, *10

The fifth row contains 10 cans.

----------------------------------------------------

b)

2+4+6+8+10+12+14+16+18+20=110

-----------------------------------------------------

c)
 
2*Row=Number Of Cans

When Row=1, Number Of Cans=2.

When Row=5, Number Of Cans=10.

When Row=10, Number Of Cans=20.
6 0
3 years ago
How do you turn a fraction to a decimal
Sindrei [870]
Divide the numerator by the denominator so for example if you had 1/2 you would divide 1 by 2 to get 0.5
7 0
3 years ago
Read 2 more answers
Other questions:
  • What is x, the length of the diagonal, to the nearest whole number
    6·2 answers
  • An airplane on auto pilot took 5 hours to travel 3,475 kilometers. What is the unit rate for kilometers per hour?
    9·1 answer
  • QUICK PLEASE HELP. I'm offering 15pt and brainliest answer.
    7·2 answers
  • What is the factorization of the trinomial below?x3 - 12x2 + 35x?
    5·2 answers
  • In the Apex Republic, 8% of the population was unemployed in May of 2006. If there were 176,000,000 people willing and able to w
    8·1 answer
  • which of the following is an arithmetic sequence? * –20, –25, –30, –35, –45, ... *–15.6, –12.9, –10.2, –7.5, –4.8, ... * 3.1, 6.
    6·1 answer
  • What is the volume olf the basketball the diameter is 9.5 round to mearest whole nu!mber<br>​
    10·1 answer
  • I need help here are points
    14·2 answers
  • The cost of a jacket at a certain store is 160% of the cost of a sweatshirt. The sweatshirt costs $34.
    14·1 answer
  • WILL GIVE BRAINLIST TO BEST ANSWER
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!