Must show ALL work and EXCEL FORMULAS used for the steps please. I need to under

Question

Must show ALL work and EXCEL FORMULAS used for the steps please. I need to understand how to use Excel and the formuals.

The computer anxiety scale rating is from a level of 20 (no anxiety) to a level of 100(highest level of anxiety). In a study of 172 people, the objective was to see if there was a difference in these levels between males and females. Xbar: MALES: 40.26 FEMALES: 36.85 S: MALE: 13.35 FEMALE: 9.42 n: MALES: 100 FEMALES:72 A. T the 0.05 level of significance, is there a difference in the variability of anxiety experienced by males and females? B. Interpret the p-value C.What assumption do you need to make about the two populations in order to justify the use of an F-test? D. Based on A & B, which t-test should you use to test to see if there is a significant difference in the mean computer anxiety between the males and females?

Explanation / Answer

For example, =A1+A2 or =5+2

For example, the formulas =SUM(A1:A2) and SUM(A1,A2) both use the SUM function to add the values in cells A1 and A2. In addition to formulas that use a single function, you can create formulas with nested functions or arrays that calculate single or multiple results.

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.