Answered You can buy a ready-made answer or pick a professional tutor to order an original one.

QUESTION

EMPLOYEE SATISFACTION STUDY

Please follow these instructions and use the attached database to successfully complete.

The scenario here is to related to “satisfaction” is one of the common quality measures for all types of organizations. While many organizations focus on patient/customer satisfaction (another component of quality measurement), we are using employee job satisfaction for this course project based on the standardized Minnesota Satisfaction Questionnaire. Any dataset will undergo similar processes of data analysis, evaluation, and application in decision making recommendations. In other words, you are completing a mini-Chapter 4 Quantitative Survey Data Analysis here.

Part 1 . Compare 2015-16 Satisfaction ratings using descriptive statistics (table summary) and create a bar chart (figure) comparing the mean values for each. Write a short paragraph explaining the data. Write the corresponding RQ and Ho/Ha related to satisfaction

Part 2. Complete an inferential statistic using a paired-comparison t test statistical test comparing 2015-16 mean values for each participant. Report the findings in a standard table (t and P values are required). Based on the P value, which hypothesis from Part 1 is supported/rejected and why. Explain your findings and conclusions in a short paragraph.

Part 3. Complete an inferential statistic using a Pearson correlation statistical test for relationship between satisfaction ratings in 2015 and 2016 for all participants in each year. Complete a scatterplot (figure) and report the findings in a standard table (r and P values are required at a minimum). Write an RQ related to the relationship with corresponding Ho/Ha. Based on the r and P values, discuss which hypothesis is supported/rejected and why. Explain your findings and conclusions in a short paragraph.

Part 4. Complete a predictive statistic (linear regression) for satisfaction ratings 2015 and 2016. Report the statistics using the standard Y = mx + b formula. Write an RQ related to the ability to predict future satisfaction based on 2015 and 16 data with corresponding Ho/Ha. Based on the P value, discuss which hypothesis is supported/rejected and why. Explain your findings and conclusions in a short paragraph. Predict what the satisfaction rating would be for 2017. Explain how accurate the prediction for 2017 satisfaction is.

Part 5. Split the data into 3 groups for each year (2015 and 16). Group 1 = participants 1-10; Group 2 = participants 11-20; Group 3 = participants 21-30. Write an RQ related to finding differences between all 3 groups and years 15-16 with corresponding Ho/Ha related to differences in group satisfaction by year. Create a bar chart (figure) comparing the mean values for each group and year. Complete an ANOVA statistical test comparing groups and years. Report the findings in a standard table (P values are required). Based on the P value, which hypothesis is supported/rejected and why. Explain your findings and conclusions in a short paragraph.

Show more
Files: MSQ QUESTIONS.docx
  • @
  • 10 orders completed
ANSWER

Tutor has posted answer for $20.00. See answer's preview

$20.00

****** ****** ***** instructions *** *** the attached ******** ** ************ completeThe ******** **** ** ** ******* to ****************** ** *** ** *** ****** ******* ******** for *** ***** of ************* ***** **** ************* focus ** **************** ************ ******** ********* ** quality ************ ** *** ***** employee job ************ for this ****** project based ** *** ************ Minnesota ************ ************* *** ******* **** ******* similar ********* ** data ******** evaluation and application ** ******** ****** *************** ** other ***** *** are completing * ************ * Quantitative ****** **** ******** ******** * ******* 2015-16 ************ ******* ***** *********** ********** (table ******** *** ****** * *** chart ******** ********* *** mean ****** for each Write * ***** ********* ********** the data Write *** corresponding ** *** Ho/Ha ******* to *********************** **************************************** ************************************************************************** ErrorStatisticStatisticmean_rating_2015303101674769505316831754496094923mean_rating_20163027120547610729357621505482453680Valid * (listwise)30AnswerAn **** ******** ****** for *********** *********** *** graph ********* **** ****** *** **** *********** in **** *** ******** the ***** ** *********** ********** above ** is perceived **** there *** **** in **** ************ ****** ******* *** *** ********* *** ********* ************ ****************** **** * ******* ***** labeled from *** **** ********* ** *** **** ************ ** (1 * **** satisfied2= satisfied3 =n ****** ********* *** ************ ** ************ * ***** ************* ** can ********* ******** **** *** ********* mean ************ rating ***** **** more client ****** **** ********* ******* **** and 2016RQ: how did *** **** satisfactory ****** change between **** *** 2016?Let d^ ** *** **** ********** ******* **** ***** ****** *** 2016 mean ratingWe can then ***** *** ********** **** * ** ** ****** **** ** ****** ** **** satisfaction rating ******* 2015 and 2016)Ha : ** ***** ****** *** increase ** **** satisfaction ****** ******* **** *** ********* * ******** ** *********** statistic ***** a ***************** * **** statistical **** ********* ******* **** ****** *** **** *********** ****** *** ******** ** * ******** ***** (t and P ****** *** required) Based ** the * ***** ***** hypothesis **** **** * ** ****************** *** *** ******* **** ******** *** conclusions ** * short paragraphWe run * ****** ****** * ********* output ** the ****** sample t test for *** ***** hypothesist-Test: ****** *** ****** *** ********* rating ******** rating ****************************************************************************** Correlation080788681Hypothesized **** **************** Stat-393119534P(T<=t) ******************* ******** **************************** ******************* ******** ******************** -393119534p = ********** approximately ******** output ** *** ***** ****** sample t ********** Samples TestPaired ***************** ***************** DeviationStd ***** ******* ********** Interval ** the ************************ ***************** * ************************************************************* p ******* 005 ****** *** * value ********** ** ********* **** than 005 we ********* reject the **** ********** *** conclude **** ***** *** increase in **** rating ******* *** **** 2015 *** ******** 3 ******** ** *********** ********* ***** a Pearson correlation *********** **** *** ************ ******* ************ ******* ** **** and **** *** *** participants in **** **** ******** * scatterplot ******** *** ****** *** findings in a standard ***** ** *** * ****** *** ******** ** * minimum) ***** ** RQ ******* ** *** ************ **** ************* ***** ***** ** *** r *** * ****** ******* ***** hypothesis ** supported/rejected *** why ******* **** ******** *** *********** ** * short ******************* output ** *** correlationCorrelationsmean_rating_2015mean_rating_2016mean_rating_2015Pearson ******************** **************** ** Squares and ******************************************************************** ******************** (2-tailed)000Sum of ******* and Cross-products1856319716Covariance640680N3030** *********** ** *********** ** *** *** level (2-tailed)Excel output ** pearson *********** ***************** ******* ******* ******** *************** with a p ***** of ***** **** (rounded off to 3dcmpace)H0 : * **** * * ≠000 is extremely **** than *** *** 001 we ********* reject *** null ********** and ******** **** *** *********** *********** ** *********** at **** 001 *** *** ****** of ***************** ** a positive *********** between *** two ********* ******* **** **** ********* *** was *** ************ ******* *** *************** average ****** ** **** *** in ********* * ******** * ********** ********* ******* regression) *** satisfaction ratings **** and 2016 Report *** ********** using the ******** * * mx * b ******* ***** ** ** ******* to *** ******* ** ******* ****** satisfaction ***** ** **** *** ** **** **** ************* ***** ***** ** *** * ***** discuss ***** ********** ** ****************** *** *** Explain **** ******** *** *********** ** a ***** paragraph Predict **** *** ************ ****** ***** ** for **** ******* how ******** *** ********** *** 2017 satisfaction ***** *** ******** ** **** ******* ************ ****** ** ********** 2016 average ************ *********** ********** *************** Entered/RemovedaModelVariables **************** RemovedMethod1mean_rating_2015bEntera Dependent Variable: mean_rating_2016b All ********* ********* ************ ************** ************** * ********* Error ** *** ************************* *********** ********** ****************************** ** ************* *********************************************************************** ********* ********* ***************** Predictors: (Constant) ************************************************ ************************ ******************** ErrorBeta1(Constant)13803164368000mean_rating_20156930968087254000a ********* ********* mean_rating_2016Excel ********** outputSUMMARY OUTPUTRegression ****************** ********* ********************* * Square0640277Standard Error0494531Observations30ANOVAdfSSMSFSignificance FRegression1128681812868185261755676E-08Residual2868476950244561Total291971587CoefficientsStandard ****** StatP-valueLower 95%Upper 95%Lower ********* 950%Intercept13799360315949436759500001560732744202712807327442027128X ******** ********************************************************** ****** * 065268 = 6527%y * ************ ******* **** ************ ****** * * ************ ******* **** ************ ******* * to *** ******** *********** ** the ******* ******* ****** in * for ***** **** ****** ** *** **** the model * ****** ******* ********** **** tests the ************ of ********** *********** *** * * =0Ha * * *** 0The ******* is ************* ***** ******* ** 0000is **** than *** and *** we ********* ****** *** null ********** *** conclude **** *** ********** coefficient * ** *********** **** ** 005 *** *** ****** of **************** an * ****** ** *** shows **** a *** ** * ****** in * *** ** ********* ** * **** ** * ****** ************** * ***** *** **** **** * ****** *** each **** (2015 *** 16) Group * * participants 1-10; ***** 2 = ************ ****** ***** * * ************ ***** Write ** RQ ******* ** ******* *********** between *** * groups and ***** ***** **** corresponding ***** related ** differences in ***** satisfaction by year ****** * bar ***** ******** comparing the **** ****** *** **** ***** *** **** ******** ** ANOVA *********** test comparing ****** and years ****** *** ******** ** a ******** ***** ** values are ********* ***** on *** P value ***** ********** ** ****************** *** why ******* **** ******** *** *********** ** * ***** paragraphAnswerRQ: is ***** *** ********** ******* the ***** group means ** **** ************ ******************* * µ1 * *** * µ3Ha * µ1 ****** *** ***** ***** ****** ** a *** *** ***** **** groupsAnova: ****** FactorSUMMARYGroupsCountSumAverageVarianceColumn ****************************** **************************** *********************************** of ************************ *********** ************************************************ ************************************** * ***** IS 318E-20this is less **** 001 ** ********* ****** *** null ********** at **** *** *** 005 levels of significance *** conclude that ** least *** ** *** ***** ***** ** different from othersGroups *** the **** 2016EXCEL ************ ****** ************************************************ 110434761943476190025724Column ****************************** *********************************** of VariationSSdfMSFP-valueF critBetween ************************************************ Groups5301814270196363Total197158729RQ: **** **** ** ************ ** ***** ******* *** ***** **** ************ ratings?hypothesisH0 * *** * *** * µ3Ha : µ1 ≠µ2 *** ****** * value ** 199E-08this is **** **** *** ** ********* ****** *** **** ********** at both *** *** 005 levels of significance *** conclude **** ** ***** *** ** *** ***** ***** is ********* **** *********** ***** *** *** OUTPUTS ** *** **** ******** ** ***** *** **** ****** **** ONE INORDER ** **** **** ******* ****** *** ********** RANGE OF ******** ***** ******* ****** ** between **** pages double ****** * ****** *** * figures ********* are *********** ** ********* ON * STANDARD ********* SATISFACTION ************* Ability ********************************************************* ********************************************************* ********************************************* ************ ************************* RelationsSupervision--TechnicalVarietyWorking ConditionsAdditionally * ******* ******* Satisfaction ***** can **** be ********* Very ************ ************ *** (Neither ********* *** **************** Dissatisfied **** ************

Click here to download attached files: MSQL ANALYSIS.docx
Click here to download attached files: minnesota.xlsx
Click here to download attached files: minessota job satisfaction survey.xlsx
or Buy custom answer
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question