Management data analysis - Assignment Example

Question 6: How many times per week do you deposit waste? The following table shows the results of the survey: Employees Gender Q 1 Q2 Q3 Q4 Q5 Q6 1 Male yes 1 1 1 23 3 2 Male yes 2 3 1 45 12 3 Male No 2 3 3 38 6 4 Female Yes 1 2 3 52 4 5 Female No 3 2 3 28 5 6 Male yes 3 2 1 18 7 7 Female yes 3 3 3 27 8 8 Female 3 3 2 33 6 9 Male No 2 3 3 56 17 10 Male Yes 2 3 3 63 21 11 Female Yes 1 1 3 39 2 12 Female Yes 1 1 1 40 7 13 Female Yes 1 1 1 33 5 14 Male no 1 3 3 22 5 15 Male yes 1 1 3 20 18 16 Female Yes 2 3 1 18 4 17 Male No 3 3 3 34 9 18 Male No 3 2 1 50 12 19 Female no 3 2 3 52 19 20 Female Yes 2 2 1 61 13 21 Male Yes 2 2 1 56 4 22 Male no 1 2 3 44 15 23 Female Yes 1 3 3 42 17 24 Female Yes 1 3 1 19 17 25 Male No 1 2 3 26 10 26 Male No 1 1 1 23 3 27 Male Yes 2 3 1 45 12 28 Male no 2 3 3 38 6 29 Female No 1 2 3 52 4 30 Female No 3 2 3 28 5 31 Male no 3 2 1 18 10 32 Female No 3 3 3 27 8 33 Female no 3 2 3 33 6 34 Male Yes 2 3 3 20 10 35 Male yes 2 3 3 63 23 Table1: survey results Null hypothesis: There is enough evidence to show that support for the new waste policy was related to the volume of waste produced prior to the policy’s introduction.

Table 2: Model Summary Model R R Square Adjusted R Square Std. Error of the Estimate 1 .025a .001 -.030 5.81551 a. Predictors: (Constant), How much waste did you generate on a typical day Table 3: ANOVAa Model Sum of Squares df Mean Square F Sig. 1 Regression .679 1 .679 .020 .888b Residual 1116.063 33 33.820 Total 1116.743 34 a. Dependent Variable: How many times per week do you visit the central re-cycling bins? b. Predictors: (Const