Estimate a simple linear regression model

Assignment Help Applied Statistics

Reference no: EM132119705

Business Data Analysis Computer Assignment -

PART 1 -

Economists believe that high rates of unemployment are linked to decreased life satisfaction ratings. To investigate this relationship, a researcher plans to survey a sample of families in Queensland. Answer the following questions:

1. What type of survey method the researcher could use and why?

2. What sampling method could be used to select the sample and why?

3. What are the variables the researcher should consider collecting data for the purpose of the analysis and why? Identify the data type(s) for the variables.

4. What kind of issues we may face in this data collection?

PART 2 -

To study the relationship between the preparation time spent by each student (in hours) for the exam and the reported mark, a sample of 100 students were selected randomly from a large statistics class. The data are stored in the file named "ASSIGNMENTDATA.XLS" in the course website. Using EXCEL, answer the following questions:

5. Using the appropriate BIN values, draw a histogram for each variable. Then, comment on the shape of the two distributions.

6. Use an appropriate plot to investigate the relationship between the two variables. Briefly explain the selection of each variable on the X and Y axes and why?

7. Prepare a numerical summary report about the data on the two variables by including the summary measures, mean, median, range, variance, standard deviation, smallest and largest values and the three quartiles, for each variable.

8. Compute a numerical summary measure to measure the strength of the linear relationship between the two variables. Interpret this value.

9. Construct a 90% confidence interval estimate for the population average time spent on preparation. Interpret the interval (use the spreadsheet on the course website).

10. Test the hypothesis that population average time spent on preparation is more than 65 hours using a 5% level of significance (use the spreadsheet on the course website).

11. Estimate a simple linear regression model and present the estimated linear equation. Then, interpret the coefficient estimates of the linear model.

12. Interpret the coefficient of determination, R-squared (R²) value.

Attachment:- Assignment Files.rar

Reference no: EM132119705

Questions Cloud

How long after the launch will the collision happen : How long after the launch will the collision happen? Ignore the size of the pucks.

Friction between the car and the disk : Ignore the rotation of the earth and any air resistance but assume friction between the car and the disk, characterized by a coefficient of friction µ.

How would you help your students visualize this : In chemical changes, new substances are formed. Do the atoms involved actually change? If not, what has changed? How would you help your students visualize this

Measures the angle of elevation to the top : A hiker measures the angle of elevation to the top of a cliff as 16.0o. She walks 1.20 km further away from the cliff on level ground, she finds the angle.

Estimate a simple linear regression model : 1305AFE Business Data Analysis Computer Assignment - Estimate a simple linear regression model and present the estimated linear equation

What speed must the player give the ball : The acceleration of gravity is 9.8 m/s2 . What speed must the player give the ball? Answer in units of m/s.

What is their velocity just after the collision : A 0.0260 kg bullet moving horizontally at 400 m/s embeds itself into an initially stationary 0.500 kg block.

Find leslie average speed : PART A: Find Leslie's average speed when she runs to the store 14 km away in 24 min

Reactions with little or no activation energy : If the reaction had NO activation energy would it be affected at all by temperature?

Reviews

len2119705

9/22/2018 3:58:48 AM

Instructions: All numerical calculations and graphs/plots should be done using EXCEL. Your assignment must be typed in a Word document in .doc or .docx format only! When answering questions, wherever required, you should cut and paste the Excel output (eg, plots, regression output etc.) to show your working/output on your assignment. You need to submit your assignment through Safe Assign in the course website, under the Assessment tab. You are required to keep a hard copy and an electronic copy of your submitted assignment to re-submit, in case the original submission is lost for some reason.

len2119705

9/22/2018 3:58:41 AM

Important Notice: As this is an individual assessment item, students should work on their own and present their individual assignment submission, even if you discuss it in a group. All assignments submitted will go through a matching process, If found to have cheated, all submissions involved would receive a mark of zero for this assessment item.

Write a Review

Required(*) Message

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages