Assignment on Simple Linear Regression
Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10 Instructions:
Assignment on Simple Linear Regression
It is well known that the famous geyser Old Faithful in Yellowstone National Park erupts quite regularly, and hence it has attracted millions of visitors. The data file “Geyser” gives information about eruptions during October 1980*. Variables are the Duration in seconds of the current eruption, and the Interval, the time in minutes to the next eruption. The park service uses data like these to obtain a prediction equation for the time to the next eruption. Such time predictions are shown to the tourists who patiently wait for the next eruption of Old Faithful.
*The data were collected by volunteers and made public by R. Hutchinson. Apart from missing data for the period from midnight to 6 am, this is a complete record of eruptions for this month.
- Using Descriptive Statistics in Data Analysis of Excel, find the 95% and 99% confidence intervals for the population means of Durationand Interval? Interpret these intervals. Compare the widths of the two Durationintervals and of the two Interval intervals, and make relevant comments about the differences in these widths.
- Using Excel, plot a scatter chart that summarizes a linear relation between Durationand Interval; have Durationon the horizontal axis and Interval on the vertical axis. Include in this chart the “trendline” and the coefficient of determination. How would you interpret the slope of this “trendline”?
- Using Regression in Data Analysis of Excel or Multiple Linear Regression in Predict of XLMiner, find the estimated regression equation for Intervalfrom Duration. Compare it with the “trendline” found in Task 2. In the output identify the coefficient of determination and compare it with that found in Task 2. What is the interpretation of this coefficient? What is the estimated variance of the error term in the assumed model ? What is the estimated standard deviation of this error term? Suppose a tourist has just arrived at the end of an eruption that lasted 3.5 minutes. What is his/her predicted waiting time in hours to the next eruption?
- Using Excel or XLMiner output found in Task 3, at the 5% significance level, conduct the t test for testing the significance of Duration. (Specify clearly your hypotheses and symbols used, indicate the value of the test statistic and the distribution of the test statistic, identify the test p-value, make your conclusion and interpret this conclusion.)
- Using Excel or XLMiner output found in Task 3, identify the 95% confidence interval for the population slope (the coefficient ) of Duration? Interpret this interval. Conduct the test in Task 4 using this interval. Did you get the same conclusion as in Task 4?
6.
- Consider a population of tourists who arrive at the end of an eruption that lasted 3.5 minutes. What is their average waiting time to the next eruption? What is the 95% confidence interval for their average waiting time to the next eruption? (Show all details of your calculations!)
- Suppose a tourist (John Smith) has just arrived at the end of an eruption that lasted 3.5 minutes. What is his predicted waiting time to the next eruption? What is the 95% confidence interval for his predicted waiting time to the next eruption? (Show all details of your calculations!)
- Explain the difference in the width of the intervals found in Tasks 6A and 6B.
Note: For the estimated regression equation and , the point prediction is obviously and you already found this prediction in Task 3.
- The confidence interval for the mean is
,
where with , = standard error of the estimate, and is the sample variance of X.
- The prediction interval for is
Use Microsoft Word to write a report with your name shown on the first page. The report should include all your Excel outputs (copy and paste them), so do not attach any separate Excel files.
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow Assignment on Simple Linear Regression