Statistical Analysis Unit 5 IP

ASSIGNMENT TEMPLATE for Week 5 IP

use this template to submit your assignment , by copying and pasting it into Word . note that points have been set aside for careful use of the template . The template parallels the assignment requirements closely and is therefore likely to help you in meeting the requirements

A title page in appropriate APA format should accompany your submission

note the page limits indicated and conform to them (3- to 4 pages ) Points 1 . Run a simple regression calculation in EXCEL using BENEFITS as the independent variable

and INTRINSIC job satisfaction as the dependent variable using all 29 data points from the AIU dataset

1 .a . Give the graph of the trendline below (To do the correlation and regression , the steps in EXCEL are as indicated on page 547 , under Correlation and Regression

In to graph a scatter plot and then insert a trendline in it , you can do the following

1 . Follow the steps on page 92 of the text to get the scatter plot

2 . Once you have the scatter plot , to include the trendline (which is also the regression line . right click directly on one of the dots on the scatter plot . Then select Add Trendline from the shortcut menu that appears 1 .b . Provide the summary results of the regression copied and pasted below from your Excel output , as shown in the text . Do not submit Excel s

SUMMARY OUTPUT

Regression Statistics

Multiple R

0 .160724

R Square

0 .025832

Adjusted R Square

-0 .01025

Standard Error

1 .184525

Observations

29

ANOVA df

SS

MS

F

Significance F

Regression

1

1 .004573

1 .004573

0 .715966

0 .404907

Residual

27

37 .8837

1 .4031 28

38 .88828 Coefficients

Standard Error

t Stat

P-value

Lower 95

Upper 95

Lower 95 .0

Upper 95 .0

Intercept

6 .639812

1 .437345

4 .619499

8 .47E-05

3 .690626

9 .588997

3 .690626

9 .588997

X Variable 1

-0 .23345

0 .275901

-0 .84615

0 .404907

-0 .79955

0 .332649

-0 .79955

0 .332649

1 .c . State regression results below in mathematical form (i .e . in the form y mx b , and explain slope and y-intercept and their signs , and explain their meanings

The regression equation is y -0 .2335x 6 .6398

The slope m -0 .2335 , this gives the rate at which intrinsic job satisfaction decreases per unit increase in the benefits

The y-intercept c 6 .6398 this is the value of intrinsic job satisfaction with no benefits

1 .d . What is the R-squared value and its significance

The R-squared value is 0 .0258 . This value lies in the range from 0 to 1 for any regression analysis . The values close to 1 means very good fit of the data and values close to 0 means poor fit of data

Small value of R-squared in this analysis means that the regression equation will give erroneous results 2 . Run a simple regression calculation using BENEFITS as the independent variable and EXTRINSIC job satisfaction as...