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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!