Attendance of undergraduate students at the business school of a prominent university was tracked throughout the semester. The dean wanted to know if there was a relationship between classification (freshman, sophomore, junior, senior) and absenteeism from classes. A random sample of 100 business students was observed. Absenteeism during the semester studied was broken into four levels (0 classes. 1-5 classes. 6-O classes. I - classes)

Attendance of undergraduate students at the business school of a prominent univensity was tracked throuphout the scmester. The dean wanted to know if there was a relationship between classification (freshman, sophomore, junior, senior) and absentecism from classes. A random sample of 100 business students was observed. Absenteeism during the semester studied was broken into four levels (0 classes, 1-5 classes, 6 - 10 classes, 11+ classes) 1. For this situation, state the null and alterative hypotheses to be tested. You can type the answers using variables or just explain in words. 2. Complete the expected frequencies in the yellow-shaded cells. Remember to use Excel for calculations. If you simply type in nambers you will not reccive crodit. 3. Use the correct Exeel formula to determine the chi-square critical value. Use 0.10 significance (4p level (alpha). 4. Reach a decision. Explain this similarly to the examples in this weck's instructional video (correspoads with examples in the book!) 5. Draw a couclusion. Explain this similarly to the examples in this week's instructional video (corresponds with examples in the book!). Attendance of undergraduate students at the business school of a prominent univensity was tracked throuphout the scmester. The dean wanted to know if there was a relationship between classification (freshman, sophomore, junior, senior) and absentecism from classes. A random sample of 100 business students was observed. Absenteeism during the semester studied was broken into four levels (0 classes, 1-5 classes, 6 - 10 classes, 11+ classes) 1. For this situation, state the null and alterative hypotheses to be tested. You can type the answers using variables or just explain in words. 2. Complete the expected frequencies in the yellow-shaded cells. Remember to use Excel for calculations. If you simply type in nambers you will not reccive crodit. 3. Use the correct Exeel formula to determine the chi-square critical value. Use 0.10 significance (4p level (alpha). 4. Reach a decision. Explain this similarly to the examples in this weck's instructional video (correspoads with examples in the book!) 5. Draw a couclusion. Explain this similarly to the examples in this week's instructional video (corresponds with examples in the book!)