1. A study asked students to report their height and then compare to the actual measured height. Assume that the paired sample data are simple random samples and the differences have a distribution that is approximately normal. Reported Height Measured Height | 67.9 68 71 63 70 71 60 65 64 54 63 66 72 69.9 64.9 68.3 70.3 60.6 64.5 67 55.6 74.2 65 70.8 a) State the null and alternative hypotheses. b) Use EXCEL to construct a 99% confidence interval estimate of the difference of means between reported heights and measured heights. Attach your printout to this question, where the reported height is column A, measured height in column B, and the difference in column C. i) Open Excel and click DATA on the ribbon of the Excel. ii) Click Data Analysis. If Data Analysis is not available, please follow the instructions in Assignment 1. iii) Select Descriptive Statistics and click OK. iv) Enter the range of the heights including the label (A1:A13). v) Select Labels in First Row. vi) Select Summary statistics. vii) Select Confidence Level for Mean and type in 99 and click OK. Calculate and write down the 99% confidence interval by hand based on the result you get from the Excel (keep four decimal places in your final answer). c) Interpret the resulting confidence interval.
1. A study asked students to report their height and then compare to the actual measured height. Assume that the paired sample data are simple random samples and the differences have a distribution that is approximately normal. Reported Height Measured Height | 67.9 68 71 63 70 71 60 65 64 54 63 66 72 69.9 64.9 68.3 70.3 60.6 64.5 67 55.6 74.2 65 70.8 a) State the null and alternative hypotheses. b) Use EXCEL to construct a 99% confidence interval estimate of the difference of means between reported heights and measured heights. Attach your printout to this question, where the reported height is column A, measured height in column B, and the difference in column C. i) Open Excel and click DATA on the ribbon of the Excel. ii) Click Data Analysis. If Data Analysis is not available, please follow the instructions in Assignment 1. iii) Select Descriptive Statistics and click OK. iv) Enter the range of the heights including the label (A1:A13). v) Select Labels in First Row. vi) Select Summary statistics. vii) Select Confidence Level for Mean and type in 99 and click OK. Calculate and write down the 99% confidence interval by hand based on the result you get from the Excel (keep four decimal places in your final answer). c) Interpret the resulting confidence interval.
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
Transcribed Image Text:1. A study asked students to report their height and then compare to the actual measured
height. Assume that the paired sample data are simple random samples and the differences
have a distribution that is approximately normal.
Reported Height
Measured Height 67.9 69.9 64.9 68.3
68
71
63
70
71
60
65
64
54
63
66
72
70.3 60.6 64.5 67 55.6 74.2 65 70.8
a) State the null and alternative hypotheses.
b) Use EXCEL to construct a 99% confidence interval estimate of the difference of means
between reported heights and measured heights. Attach your printout to this question,
where the reported height is column A, measured height in column B, and the difference
in column C.
i) Open Excel and click DATA on the ribbon of the Excel.
ii) Click Data Analysis. If Data Analysis is not available, please follow the instructions
in Assignment 1.
iii) Select Descriptive Statistics and click OK.
iv) Enter the range of the heights including the label (A1:A13).
v) Select Labels in First Row.
vi) Select Summary statistics.
vii) Select Confidence Level for Mean and type in 99 and click OK.
Calculate and write down the 99% confidence interval by hand based on the result you get
from the Excel (keep four decimal places in your final answer).
c) Interpret the resulting confidence interval.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 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