Could you please help me using step by step on excel. Thank you

AnnArbor_Rental. Real Estate investment in college towns continues to promise good returns (The Wall Street Journal,September 24, 2010).Marcela Treisman works for an investment firm in Michigan.Her assignment is to analyze the rental market in Ann Arbor, which is home to the University of Michigan.She gathers data on monthly rents for 2011 along with the square footage of 40 homes.A portion of the data is shown in the accompanying table.

Full data file in Excel -Use full data file to calculate

I'll send the excel file

1. Construct 90%and 95% confidence intervals for the mean rent for all rental homes in Ann Arbor, Michigan.
2. Construct a 90% and 95% confidence intervals for the mean square footage for all rental homes in Ann Arbor, Michigan.

Chapter 8 Ann Arbor Data Q Search Sheet Home nsert Draw Page Layout Formulas Data Review View '+ Share 9 . 53 . Get Add-ins EY Slicer + A Tt Equation PivotTable Recon e Recommended Table Pictures Shapes Icons PivotTables My Add-ins EXI Recommended Charts ::. Maps PivotChart Sparklines Timeline Link New Text Header & Comment Box Footer symbol x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates C1 4 X V J C D E F G H K M N 0 P Q R Monthly Rent S Square footage T U V W X Y 2 645 500 3 675 648 4 700 5 800 903 6 820 817 7 920 8 855 900 9 859 886 10 900 1000 11 920 12 876 13 929 920 14 960 975 15 975 1100 16 940 17 1000 18 1299 19 1164 20 1049 1180 21 1050 1162 22 1163 23 1020 24 1150 25 1225 26 1368 27 1275 1400 28 1275 1350 29: 1185 30 1450 1200 31 1 1412 32 1518 1700 33 1440 34 1460 35 1635 1460 36: 1650 1170 37 1750 1944 38 1950 2265 39 1700 40 2200 4319 41 2700 42 Sheet1 + Average: 1254.475 Count: 82 Sum: 100358 + 100%