Calculating the linear regression model using excel

Reference no: EM1319759

Run a regression of Y on X in Excel and turn in the output with a note explaining what the coefficients {correlation coefficient (multiple R), standard error, t-statistic and F-statistic} mean.

Family	Weekly Expenditure On Recreation (Y)	Weekly Income (X)
1	90	900
2	60	800
3	45	600
4	70	650
5	30	300
6	40	350
7	50	400
8	55	700
9	85	950
10	75	700
11	90	800
12	70	750
13	60	500
14	40	300
15	25	250
16	65	700
17	60	600
18	50	450
19	35	250
20	35	200

Reference no: EM1319759

Questions Cloud

Implication of culture and diversity : Why do leaders need to understand the implication of culture and diversity? Does building a learning organization add to being able to capitalize on this?

Probability using normal distribution-z score : What was the cost for the 10 percent of employees who incurred the highest dental expense?

Potential lawsuits : Martin, Barry, and Sims each have $4,000 to contribute toward an office supply business that they would like to start up. They are aware that there will be stiff competition in the business district where they will be opening.

Success factors for organisation : What are the key success factors for the organisation you work for (or another you know well) to achieve competitive advantage in the markets for its products/services?

Calculating the linear regression model using excel : Run a regression of Y on X in Excel and turn in the output with a note explaining what the coefficients {correlation coefficient (multiple R), standard error, t-statistic and F-statistic} mean.

Role of ethics committee in modern healthcare : What is the role of an ethics committee in a modern healthcare facility? Do some research, and present at least three issues which come before ethics committees.

Calculating correlation using scatter diagram : Develop a scatter diagram for the data and write a brief summary.

Operations strategy and competitive priorities : How has operations strategy and competitive priorities evolved in the automobile industry during the last 100 years?

Most or least number of condiments : What can you conclude regarding the information? Who tends to order the most or least number of condiments?

User Account

All Pages