1 A Study Asked Students To Report Their Height And Then Compare To The Actual Measured Height Assume That The Paired 1 (105.18 KiB) Viewed 15 times
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 68 71 Measured Height 67.9 69.9 63 70 71 60 64.9 68.3 70.3 60.6 65 64 54 63 66 72 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.
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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!