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

Applied Statistics Questions & Answers

Find an example of misleading use of statistics in magazine

Find an example of a misleading use of statistics in a newspaper, magazine, corporate annual report, or other source. Then explain why your example is misleading.

What statistics would you need to know to expose

"The larger the sample, the more reliable the results." Do you agree or disagree with this statement? Explain -

Find a confidence interval for the mean of possible yields

Using the Excel output in Figure 8.14, find a 95 percent confidence interval for the mean of all possible yields obtained using catalyst XA-100.

Hdtv''s need repairs at the manufacturer expense

The warranty period must be long enough to make the purchase attractive to the buyer. For a new HDTV the mean number of months until repairs are needed is 36.84 with a standard deviation of 3.34 months. Where should the warranty limits be set ..

What is the probability that x assumes a single value

Let x be a continuous random variable. What is the probability that x assumes a single value, such as a (use numerical value)?

Graphing a nominal independent variable

1) There are 2 types of graphs that are best to use when graphing two scale variables. Which 2 graphs are these? 2) When graphing a nominal independent variable and a scale dependent variable, you could use a ____________ or a ____________.

The higher the anxiety level of the participant

The higher the scores on these measures, the higher the anxiety level of the participant.

Two variables that have perfect positive linear correlation

A.Two variables that have perfect positive linear correlation are the price per gallon of gasoline and the total cost of gasoline. Two variables that have perfect negative linear correlation are the distance from a door and the height of a wheelchair..

Discussing perhaps the most crucial part

Discussing perhaps the most crucial part of your research. Recall your initial predictions of what you expected to find before you began your research. Now, using what you learned this week about Hypothesis Testing, you will formally test your predic..

An article that deals with sleep and shift-workers1what can

an article that deals with sleep and shift-workers.1.what can you tell us about the journal that this article was

Compare the two means and standard deviations

To begin with find the mean and standard deviation of each set of data. Compare the two means and standard deviations, intuitively does it appear that there has been improvement in water quality?

Machines continuously process an unending number of jobs

Three machines continuously process an unending number of jobs. The time it takes to process a job on machine A is a Uniform [0,4] random variable, the time it takes to process a job on machine B is Uniform [1,3] random variable, and the time it take..

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