Question

In: Statistics and Probability

How do I use the data analysis in Excel to figure these questions out? Suppose a...

How do I use the data analysis in Excel to figure these questions out?

Suppose a researcher gathered survey data from 19 employees and asked the employees to rate their job satisfaction on a scale from 0 to 100 (with 100 being perfectly satisfied). Suppose the following data represent the results of this survey. Assume that relationship with their supervisor is rated on a scale from 0 to 50 (0 represents a poor relationship and 50 represents an excellent relationship); overall quality of the work environment is rated on a scale from 0 to 100 (0 represents poor work environment and 100 represents an excellent work environment); and opportunities for advancement is rated on a scale from 0 to 100 (0 represents no opportunities and 100 represents excellent opportunities).

Answer the following questions:

  1. What is the regression formula based on the results from your regression?
  2. How reliable do you think the estimates will be based on this formula? Explain your answer by citing the relevant metrics.
  3. Are there any variables that do not appear to be good predictors of job satisfaction? How can you tell?
  4. If a new employee reports that her relationship with her supervisor is 40, rates her opportunities for advancement to be at 30, finds the quality of the work environment to be at 75, and works 60 hours per week, what would you expect her job satisfaction score to be?

Job satisfaction

Relationship with supervisor

Opportunities for advancement

Overall quality of work environment

Total hours worked per week

55

27

42

50

52

20

35

28

60

60

85

40

7

45

42

65

35

48

65

53

45

29

32

40

58

70

42

41

50

48

35

22

18

75

55

60

34

32

40

50

95

40

48

45

40

65

33

11

60

38

85

38

33

55

47

10

5

21

50

62

75

37

42

45

43

80

37

46

40

42

50

31

48

60

46

90

42

30

55

38

75

36

39

70

43

45

20

22

40

42

65

32

12

55

53

Solutions

Expert Solution

Enter the data into Excel.

Now, go to Data > Data Analysis > Regression.

Select the input range and click OK. Check Labels too.

The output is:

  1. What is the regression formula based on the results from your regression?

y = 98.32909 + 1.323244*x1 + 0.077349*x2 - 0.17004*x3 - 1.52239*x4

  1. How reliable do you think the estimates will be based on this formula? Explain your answer by citing the relevant metrics.

R-square = 0.82

Since 82% of the variation in the model is explained, we can say that the estimates are reliable.

  1. Are there any variables that do not appear to be good predictors of job satisfaction? How can you tell?

Opportunities for advancement is not a good predictor of job satisfaction.(p > .05)

Overall quality of work environment is not a good predictor of job satisfaction.(p > .05)

  1. If a new employee reports that her relationship with her supervisor is 40, rates her opportunities for advancement to be at 30, finds the quality of the work environment to be at 75, and works 60 hours per week, what would you expect her job satisfaction score to be?

y = 98.32909 + 1.323244*40 + 0.077349*30 - 0.17004*75 - 1.52239*60 = 49.48292

Please give me a thumbs-up if this helps you out. Thank you!


Related Solutions

I am trying to figure out which test analysis to use for my research questions. I...
I am trying to figure out which test analysis to use for my research questions. I was thinking about think about multivariate because of the number of variable being addressed in the study but there is also the possibility to use univariate to address each question. What are the current levels of police satisfaction in CMPD jurisdictions? What is the public’s perception of crime in CMPD jurisdictions? Does “hot spot” policing reduce crime in CMPD jurisdictions? How does broken windows...
Use EXCEL and DATA ANALYSIS to find the answers to these questions. Provide all EXCEL printouts...
Use EXCEL and DATA ANALYSIS to find the answers to these questions. Provide all EXCEL printouts and 6 step write-ups for each of the two problems. A food company is concerned about recent criticism of the sugar content of their children’s cereals. The data show the sugar content (as a percentage of weight) of 15 national brands of children and adult cereals. Children’s Cereal’s Adult’s Cereal 40.3 20.5 55 30.2 45.7 22.2 43.3 27.5 50.3 34.4 45.9 22.2 53.5 16.6...
I have to figure this out in Excel. I have 4 columns with names in a...
I have to figure this out in Excel. I have 4 columns with names in a spreadsheet. I am trying to find the duplicates between columns and count them. Example A B C D Steve John Chris John Sarah Steve John Sarah Carl Chris Paul Paul Jenna Logan Sarah Jenna Moe Norman Joe Logan I am trying to identify the names that show up in multiple columns and count the times they show up, all in Excel. Which excel functions...
I am supposed to map out the following and can't figure out how to do it!...
I am supposed to map out the following and can't figure out how to do it! Can somebody help? The experiment has to do with determining the simplest formula of potassium chlorate and to determine the original amount of potassium chlorate in a potassium chlorate-potassium chloride mixture by measuring the oxygen lost from decomposition. The chemical reaction is 2KClO3(s) ------> 2KCL(s) + 3 O2(g) I am supposed to map out 1. Mass of oxygen lost in the first part 2....
-please answer this written out. Do not use excel I cannot access it. i need to...
-please answer this written out. Do not use excel I cannot access it. i need to know how to do it on paper- Deluxe River Cruises operates a fleet of river vessels. The fleet has two types of vessels: A type A vessel has 60 deluxe cabins and 160 standard cabins, whereas a type B vessel has 80 deluxe cabins and 120 standard cabins. Under a charter agreement with the Odyssey Travel Agency, Deluxe River Cruise sis to provide Odyssey...
How do I do this in excel? The data contains data on monthly mortgage payments for...
How do I do this in excel? The data contains data on monthly mortgage payments for 150 homeowners for year 2010 and year 2015. Note that this is a matched sample. Using the appropriate Excel data analysis tool or formulas, test the hypothesis to determine if mortgage payments have risen from 2010 to 2015. The data is too long. If you can make a small example with random variables. Use α = .05. State hypothesis used for this.
Use MATLAB to figure out the following problem, if you do not know how to use...
Use MATLAB to figure out the following problem, if you do not know how to use MATLAB then please do not answer. Coding is required for the exercise. For f(x) = arctan(x), find its zeros by implimenting Newtons method and the Secant method in Matlab. (Hint: Use Newtons method to calculate x1 for Secant method) Comment all code please since I would like to learn how to do this correctly in MATLAB. Thank you.
Hi, I can't figure out this question in excel, can someone please show me the excel...
Hi, I can't figure out this question in excel, can someone please show me the excel formulas to input in order to solve for part A and B please!!!! The following table contains closing monthly stock prices for Oracle Corporation (ORCL), Microsoft Corporation (MSFT), and NVidia (NVDA) for the first half of 2017. Ticker 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 ORCL 50.14 45.39 44.96 44.61 42.59 40.11 MSFT 68.93 69.84 68.46 65.86 63.98 64.65 NVDA 144.56 144.35 104.3 108.93 101.48...
USE EXCEL You’re bored at work and so want to figure out how long until you...
USE EXCEL You’re bored at work and so want to figure out how long until you can retire. Suppose that you have $700,000 in savings today (today is 1-Jan-2021). This savings account earns a 3% return each year. Specifically, the interest accrues each day at a daily rate of 0.03/360, and the interest compounds annually (i.e. the interest gets added to the interest-earning principal at the end of each year). From your salary, you will contribute $22,000 in additional savings...
i. Use MS Excel Data Analysis ToolPak to perform a multiple regression analysis using Quality as...
i. Use MS Excel Data Analysis ToolPak to perform a multiple regression analysis using Quality as the response variable and Helpfulness and Clarity as the explanatory variables. Write down the corresponding coefficient estimates and provide the regression output. j. Perform an F-test for the overall usefulness of the model in part i) using a 5% significance level. Make sure you follow all the steps for hypothesis testing indicated in the Instructions section and clearly state your conclusion. k. Test manually...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT