Question: Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF ABP ? C ... lome Insert Draw Page Layout MAT312 Excel Formulas Data

Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF ABP ? C ... lome Insert Draw Page Layout MAT312 Excel Formulas Data Review X V fx View ? Tell me A D E F G H Student Name: K L M Annual Returns (%) for 20 randomly sampled firms in health and info tech. Health Information Complete the appropriate statistical test using Excel functions/tools and display results in the Technology cells below. 10.29 4.77 -Test: Two-Sample Assuming Unequal Variances 32.17 1.14 34.27 12.72 Variable 1 Variable 2 10.57 48.1 Mean 18.9085 20.037 20.27 6.69 Variance 115.2479 523.0945 10 31.43 11.65 Observation 20 20 11 15.4 53.28 Hypothesiz 12 0.88 10.41 df 27 13 17.85 50.88 It Stat -0.19975 14 28.98 48.63 P(T
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
