Please help to find the correct EXCEL FORMULA for the t-value. Please make sure to give the correct EXCEL FORMULA. Thanks!
Please help to find the correct EXCEL FORMULA for the t-value. Please make sure to give the correct EXCEL FORMULA. Thanks!
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Please help to find the correct EXCEL FORMULA for the t-value. Please make sure to give the correct EXCEL FORMULA.
Thanks!
Transcribed Image Text:Review
View
Help
O Editing v
Arial
v 11
B Av
E a6 Merge vGeneral
00
B12
fr =T.DIST.2T(0.05,B11-1)
00
A
B
E
F
G
H
Suppose that a popular museum is interested in estimating the average age of summer visitors. A random sample of summer
visitors is selected. The data is recorded in tab "Age",
2
3.
The researchers want to determine a 95% confidence interval around the mean weight of all summer visitors.
6 Required:
Determine the following:
Mean
7
8
38.3125O
In
13.41986371 0
2.372319158O
32 0
0.960443165 X
Standard Deviation
10 Standard Error
11 Sample Size
12 t-Value
Lec
13
need
14 Margin of Error without using Confidence.t
15
4.838376821
worksp
16 Now compute the Margin of Error using Confidence.t
17
18 Upper Bound Confidence Interval
19 Lower Bound Confidence Interval
20
21
22
Transcribed Image Text:Review
View
Help
O Editing v
Anal
A
Merge v
General
$v 、@、屏
B12
fx =T.DIST.2T(0.05,30)
00
B
D
F
G
Suppose that a popular museum is interested in estimating the average age of summer visitors. A random sample of summer
McGra
2
visitors is selected. The data is recorded in tab "Age".
Check
The researchers want to determine a 95% confidence interval around the mean weight of all summer visitors
x Your
Required:
Determine the following:
8 Mean
Standard Deviation
10 Standard Error
Question
38.3125 O
Integrated Exc
13.419863710
2.372319158 C
Legend
11 Sample Size
12 t-Value
32
0.960453809 X
Graded cell L
13
needed.
14 Margin of Error without using Confidence.t
Scratchpad Use
15
4.8383768210
workspace
16 Now compute the Margin of Error using Confidence.t
17
18 Upper Bound Confidence Interval
19
Lower Bound Confidence Interval
20
21
Contaun
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman