Question: Based on the below tables, test whether the NYSE stocks have larger market values than the NASDAQ stocks at the 5% significance level? Can I
Based on the below tables, test whether the NYSE stocks have larger market values than the NASDAQ stocks at the 5% significance level? Can I ask for the explanation to be conducted on Excel (using Excel data analysis). Thanks.
F-Test Two-Sample for Variances
NYSE Market Cap
Mean: 12,091.945
Variance: 619,088,537.819
Observations: 56
df: 55
F: 45.617
P(f<=f) one-tail (p-value): 0
F Critical one tail: 1.626
NASDAQ Market Cap
Mean: 2,568.587
Variance: 13,571,445.312
Observations: 44
df: 43
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
