Question

please use excel!!!!!

the following problems and answer the following questions. Document, justify or 1 of 1 any calculations and computations. Even if working as a group, each group member er or his own copy of the solutions as documentation. Using appropriate technology is encouraged when appropriate; however, such work must be fully documented or explained. Software printouts or spreadsheet copies should include your name within the text so to verify the work as your own. Your work must be submitted electronically here through this ASSIGNMENT function within BLACKBOARD, right where you obtained this file. Follow the prompts. You should include this cover sheet, plus your actual solutions, answers and/or graphs. The head housekeeper at the Palisades Point Humane Habitat, a no-kill adoption organization for cats and dogs, wonders whether (a) the individual staff member or (b) the day of the week might impact the average number of the pets' sleeping spaces or cages cleaned during one eight-hour shift. She asks an office assistant to run some statistical tests to explore these two questions, using the data in the following table. Based on the available evidence, and testing at the 10% level of significance, is there any difference between (a) the mean number of sleeping spaces or cages cleaned according to staff members and (b) the mean number of sleeping spaces or cages rooms cleaned according to days of the week? Explain, utilizing appropriate inferential analytic methods. [COMMENTS& HINTS: Use software to your advantage. Be sure to state explicitly the hypotheses (both null and research/alternative), the conclusions (technical and contextual), and the p-values both for staff and for days of the week.] 34 46 35 47 32 38 39 37 Ari Betty Carlos Dante Enid Fatima 35 49 46 37 29 47 37 36 49 41 42 Scoring Rubric for AC09 ## | Components #1 a l Adequate, accurate solution, complete and correct #1b | Adequate, accurate solution, complete and correct Values Credit 10.0 points 10.0 points TOTAL: 20 points

Answer 1

Anova in excel

1. Arrange the data in excel as shown below.

HS374737 333433 4 443444 GF41-691 FT79-845- 333444 EN329779 342433 359636 434434 D T 289324 333444 BS-465764 343444 s-e ABCDEF 123456789

2. Select two-factor anova without replication from the data analysis tab.

Data Review View Developer Help Tell me what you want to do 蛆Group, +--Data Analysis Connections AI ZIA × Clear what-If Forecast 2Bungroup ▼ Analysis-sheet E Subtotal ?,Solver ZI Sort Filter Reapply 7Advanced Columns co▼ Sort & Filter Data Tools Forecast Outline Analyze ections Data Analysis Analysis Tools Anova: Two-Factor With Replication 37 34 47 OK 36 49 41 Anova: Two-Factor Without Replication Correlation Covariance Descriptive Statistics Exponential Smoothing F-Test Two-Sample for Variances Fourier Analysis Histogram Moving Average Cancel Help 37

3. Input the value as shown.

2 Ari 3 Betty 4 Carlos 5 Dante 6 Enid 7 Fatima 34 46 35 47 46 32 38 39 43 42 Anova: Two-Factor Without Replication 43 35 49 46 37 39 38 42 29 47 37 39 37 34 47 Labels Input Range: 36 49 41 SA$1:SHS7 Cancel 45 Alpha: 0.05 46 Help 37 Output options OOutput Range O New Worksheet Ply: O New Workbook 10 SM$1 12 13

4. The output will be generated as follows.

Anova: Two-Factor Without Replication SUMMARY SumAverage Variance Count Ari Betty Carlos Dante Enid Fatima 256 36.57143 24.95238 278 39.71429 13.2381 260 37.14286 37.80952 323 46.14286 4.142857 277 39.57143 28.61905 295 42.14286 10.47619 252 238 39.66667 19.46667 252 227 37.83333 40.96667 244 40.66667 10.66667 255 221 36.83333 28.16667 42 6 34.8 42 42.4 18.7 42.5 ANOVA Source of Variation df P-value Fcrit MS 435.6429 5.238 540.1905 Cleaners 5 87.12857 4.838769 0.002312 2.533555 Rows Days of the week Columns 6 29.20635 1.622003 0.175507 2.420523 30 18.00635 Error 41 Total 1151.071

Hypothesis 1

Ho: The average pets' sleeping spaces or cages cleaning is equal for all staff members.
H1: The average pets' sleeping spaces or cages cleaning is not equal for all staff members.

From the ANOVA output, we look at the pvalue which is 0.002(highlighted in yellow). Since the pvalue is less than 0.1, we reject the null hypothesis and conclude that the average pets' sleeping spaces or cages cleaning is not equal for all staff members.

Hypothesis 2

Ho: The average pets' sleeping spaces or cages cleaning is equal for all days of the week.
H1: The average pets' sleeping spaces or cages cleaning is not equal for all days of the week.

From the ANOVA output, we look at the pvalue which is 0.1755(highlighted in blue). Since the pvalue is greater than 0.1, we fail reject the null hypothesis and conclude that the average pets' sleeping spaces or cages cleaning is equal for all days of the week.