QUIZ 3.xlsx - The data provided in this file represents a random sample of Students enro scores examm score and their course section,etc is collected

QUIZ 3.xlsx - The data provided in this file represents a...

This preview shows page 1 - 14 out of 42 pages.

PANTHER ID ENTER YOUR NAME: 5634290 Today's Date and Time Application Username Erick QMB Assignment Florida International Un May-19 The data provided in this file represents a r scores, examm score and their course secti INCLUDE SUPPORTING CALCULATIONS, FOR not acceptable.
Image of page 1

Subscribe to view the full document.

Name Lorena Amable 7/8/2019 19:06 Created by Dr. Gladys Simpson niversity random sample of Students enrolled in a course in a given term. Stu tion,etc is collected.. You can assume that all assumptions for using s RMULAS OR PIVOTS TABLES YOU USE TO RESPOND TO ALL QUESTION [email protected]
Image of page 2
udents'information about course statistical procedures are met. NS. Entering only the answers is
Image of page 3

Subscribe to view the full document.

1 10/11/2019
Image of page 4
Image of page 5

Subscribe to view the full document.

Image of page 6
7/15/2019
Image of page 7

Subscribe to view the full document.

10/11/2019 6/1/2019
Image of page 8
Student SECTION ExamOption 91 HYBRID THU11AM 85% 96% 16 ONLINE PROCTORU 86% 95% 63 HYBRID THU11AM 97% 108% 43 HYBRID THU11AM 84% 95% 9 REGULAR TUE8PM 91% 101% 73 ONLINE PROCTORU 73% 79% 30 ONLINE TUE8PM 73% 79% 87 ONLINE TUE8PM 85% 95% 25 ONLINE PROCTORU 70% 77% 39 REGULAR NOT COMPLETED 85% 93% 19 REGULAR TUE8PM 89% 98% 64 REGULAR TUE8PM 94% 104% 77 REGULAR TUE8PM 65% 69% 27 ONLINE PROCTORU 78% 86% 41 ONLINE PROCTORU 81% 89% 55 ONLINE TUE8PM 89% 98% 66 HYBRID THU11AM 74% 80% 1 REGULAR TUE8PM 50% 52% 67 ONLINE THU8AM 89% 96% 32 ONLINE PROCTORU 96% 104% 89 REGULAR NOT COMPLETED 93% 104% 38 ONLINE PROCTORU 8% 12% 24 HYBRID THU11AM 98% 109% 3 REGULAR TUE8PM 73% 83% 52 REGULAR TUE8PM 94% 103% 49 ONLINE PROCTORU 95% 105% 68 REGULAR THU8AM 94% 102% 57 REGULAR TUE8PM 91% 100% 51 HYBRID THU11AM 79% 87% 60 HYBRID THU11AM 85% 91% 37 ONLINE TUE8PM 92% 99% 34 REGULAR TUE8PM 89% 98% 44 HYBRID THU11AM 70% 76% 17 HYBRID THU11AM 61% 70% 15 ONLINE PROCTORU 52% 61% 2 ONLINE PROCTORU 95% 106% 62 HYBRID THU11AM 79% 84% OVERALL SCORE TOTAL SCORE
Image of page 9

Subscribe to view the full document.

80 ONLINE THU8AM 39% 43% 82 ONLINE PROCTORU 67% 76% 8 REGULAR THU8AM 93% 100% 58 HYBRID THU11AM 90% 101% 100 HYBRID THU11AM 98% 107% 11 REGULAR TUE8PM 89% 100% 54 HYBRID THU11AM 90% 101% 4 ONLINE PROCTORU 90% 101% 35 ONLINE PROCTORU 94% 104% 99 REGULAR TUE8PM 36% 42% 36 ONLINE THU8AM 60% 65% 45 REGULAR TUE8PM 52% 61% 26 ONLINE PROCTORU 91% 101%
Image of page 10
ENABLE CONTENT (MACROS) TO load data. 95% A 61% A 88% A 75% A 86% A 37% B 14% B 78% A 24% C 43% A 67% A 96% A 68% D 46% B 40% B 55% A 60% B 42% F 58% A 92% A 80% A 12% F 89% A 73% B 49% A 76% A 81% A 63% A 83% B 63% A 36% A 74% A 51% C 53% D 52% D 89% A 36% B EXAM SCORE LETTER GRADE
Image of page 11

Subscribe to view the full document.

29% F 51% C 72% A 84% A 79% A 82% A 77% A 89% A 73% A 63% F 94% D 67% F 70% A
Image of page 12
QUESTION 1 Historical data for the class shows that the average Exa Does this sample provide significant evidence that ave Include the Test Statistic and P value. Use significance le a.Which variable or variables from the data set will you use to respond to this question ? b.Which type of inference procedure will you use to respond to this question ? Test Statistic -4.03 P value 0.0001 Conclusion There is evidence that the average EXAM SCORE has changed INCLUDE BELOW ANY SUPPORTING EXCEL OUTPUT OR TEMPLATE YOU USED TO SOLVE THIS QU HYPOTHESIS TEST For ONE MEAN When σ KNOWN Significance level alpha 1% 75.00% Sample mean (x) 0.641 Finite Population ? No 19.09% Sample size ( n ) 50 1.000 smpl distr std dev 0.027 One tail test statistic z -4.03 2.3263 ONE SIDED ALTERNATIVE Hypotheses Ho : µ >= 0.75 Ho : µ <= 0.75 Ha : µ < 0.75 Ha : µ > 0.75 P Values P-value 0.000 P-value 0.999971672 Reject Ho Fail to Reject Ho HYPOTHESIS TEST For ONE MEAN When σ UNKNOWN Ho: Pop mean( µ ) = Population std dev ( σ ) = z* critical Value There is evidence at 1%
Image of page 13

Subscribe to view the full document.

Image of page 14
  • Summer '16

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes