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
Solve the proportion 9/12=15/x
Nikolay [14]

Answer:

20

Step-by-step explanation:

3/4=15/x

4/3=x/15

4/3*15=x

X=20

5 0
3 years ago
Read 2 more answers
Help me please <br><br> will get rewared brainly if correct answer
larisa [96]

Well, split it into 3 shapes

21 x 10 = 210

3 x 6 = 18

2 x 6 = 12

210 + 18 + 12 = 240 square cm

imahe for more context

plzzz give me brainliest

5 0
3 years ago
URGENT 30 POINTS An engineer needs to find the length of a beam to support the beam holding the wall. If the two beams are perpe
alexandr402 [8]
The answer is not m= 95.
5 0
3 years ago
Shania is planning a party at her home. She has made 126 chocolate truffles and 84 caramel truffle to give to her guests if ther
Triss [41]
Each person would receive 6 chocolate truffles and 4 caramel truffles because 126÷21=6 and 84÷21=4.
3 0
3 years ago
Most ATM’s require a 4-digit code using the digits 0-9 how many 4-digit codes can you use
Zolol [24]

10000 digits can be used for 4 digit A.T.M code.

<u>Solution:</u>

Given that A.T.M required 4 digit codes using the digits 0 to 9.  

Need to determine how many four digit code can be used.

We are assuming that number starting with 0 are also valid ATM codes that means 0789 , 0089 , 0006 and 0000 are also valid A.T.M codes.

Now we have four places to be filled by 0 to 9 that is 10 numbers

Also need to keep in mind that repetition is allowed in this case means if 9 is selected at thousands place than also it is available for hundreds, ones or tens place .  

First digit can be selected in 10 ways that is from 0 to 9.

After selecting first digit, second digit can be selected in 10 ways that is 0 to 9 and same holds true for third and fourth digit.

So number of ways in which four digit number is created = 10 x 10 x 10 x 10 = 10000 ways

Hence 10000 digits can be used for 4 digit A.T.M code.

7 0
3 years ago
Other questions:
  • If a bus travels 20 km in 30 minutes. What is the average speed of the bus?
    6·2 answers
  • (HELP IM GONNA GET BAD GRADES)
    9·2 answers
  • The Pythagorean theorem, also known as the pythagoras’ theorem, is a fundamental relation in the geometry among the three sides
    7·1 answer
  • 8 students share 5 square pieces of cake equally
    6·2 answers
  • State whether every point on the graph is a solution of the equation. Explain why or why not. x – 4y = –4 A. Every point shown o
    12·1 answer
  • PLEASE HELP ME, I WOULD APPRECIATE IT. What is the perimeter of the figure below?
    12·1 answer
  • What is it called when columns filled with pairs of numbers that have the same ratio
    9·1 answer
  • How do you write the equation of a circle if you know it's radius and the coordinates of its center
    14·1 answer
  • For each of these intervals, list all its elements or explain 2.1 Sets 131 why it is empty. a) [a,a] c) (a, a] e) (a,b), where a
    9·1 answer
  • Urgent!! Please answer this. thankyou!
    6·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!