Using the attached Excel
Homework 3 Data Inputsfile (it contains the results of Frequency analysis completed in SPSS, as illustrated in class), you are to compute 95% (α=0.5) AND 99% (α=.01) confidence intervals for all 5 variables included in the said Excel file (please note that you will need to identify the appropriate parts of the output and use appropriate confidence interval formulations).
Sheet1 Statistics TotalSpendCarValueHouseholdIncomeAgeBrandTenure_Months NValid50005000500050005000 Missing00000 Mean159.3570$23,232.5800$54,742.800047.0338.20 Std. Error of Mean2.33725$300.26069$782.167610.2510.320 Median100.8000$17,000.0000$38,000.000047.0038.00 Mode20.00-$1,000.00$22,000.001872 Std. Deviation165.26859$21,231.63670$55,307.6019617.77022.662 Minimum3.80-$1,000.00$9,000.00180 Maximum1403.85$99,600.00$1,073,000.007972 Percentiles2535.8000$9,200.0000$24,000.000031.0018.00 50100.8000$17,000.0000$38,000.000047.0038.00 75226.9875$31,100.0000$67,000.000062.0059.00