I continue to brake my head with this assignment to the point that my professor says I keep getting this wrong. I got a 10/50 last time I tried this and I truly don't know what I Am doing wrong. Can someone please help me understand this? She wants this in an excel document which I get that because it's easier to write formula and do graphs there but I give up.

The data file attached consists of 3 worksheets:

1. Housing Features

2. Housing Median 1996-2018

3. Stock Returns

Excel Project Output I

1. Data: Housing Features

1.1 Frequency Distribution & Bar chart.Which variable of data 1. Housing Features is described best with a bar chart? Choose the variable and make a frequency distribution and a bar chart with the data.

1.2 Frequency Distribution & Pie chart. Which variable of data 1. Housing Features is described best with a pie chart? Choose the variable and make a frequency distribution and a pie chart the data.

1.3 Frequency Distribution & Histogram. Which variable of data 1. Housing Features is described best with a histogram?Organize the data into a frequency distribution and a histogram.

Follow the guideline: The data for 1.3 need to be organized into 10 classes and the first class begins from 70.Figure out class width and define 10 classes.Based on your class definition, make frequency distribution and histogram.

2. Data: Housing Median 1996-2018

2.1 Which chart is the best for this type of data?Make the chart to show median price change over time (Aug. 1996 ~ July 2018).On one chart, show the change of both ('median of top tier' and 'median of bottom tier') over time.

3. Data: Stock Returns: There is nothing for you to submit for output I submission

Excel Project Output II

(Numbering continues from output I)

1. Data: Housing Features.

(1.1 through 1.3 belong to output I submission)

1.4"Descriptive Statistics" Table for the variable "sale price per square foot"

2. Data: Housing Median 1996-2018 -------Output of this belongs to output I.You have nothing to submit in output II

3. Data: Stock Returns

3.1 Correlation Coefficient Matrix

3.2 Read your correlation coefficient matrix.Choose a pair that has the strongest positive correlation.With the two stocks your chose, make a scatter Plot.

3.3 Read your correlation coefficient matrix.Choose a pair that has the strongest negative correlation.With the two stocks your chose, make a scatter Plot.

Observat | community in the With Ho with Home Owners Estimated Bins Value P Data 1. Hoy sFeatures a $ are from 181 rans ransomly sampled square ft houses. The data show 181 observations' community nam HOA affiliation, estimated value per sq ft of the observed Tes 123 Regarding problem 1.3: Before you run "Histogra procedure, e, do followings first. 1. Define (which means decide class width, and class limits each class) classes. Guideline: number of classes are 10 and first class begins from 70. 2. Based on class limits, figure out upper boundary of each class, 3. Fill up "Bins" column with each class's upper boundary. starting from cell E2, type 1st class's upper boundary ; in the ell E3, type 2nd class's upper boundary. ... go on th cell E11 with upper boundary of the 10th class. through the 4. Data -->Data Analysis->Histogrammmmm Mnnal'lcp'md Mummy... mm mm woo mm) mm um um mm m was um mu m. um AM m w m 4m my.\" m m \"an: 14730:: m mm m an mm m saw as: m moo mu: m um mu: m m mm m: N um- mm 54):: mm m um mm M Jan mm mm 50 mm mm m mu! m m mu- m mm: mm mm m mu mm ma mm 1m 5m mun-m m mm man mm m mu um um mm mm mm mm am mu m a: mm mm: mu mm sum was um m was 1m mm mm: mm um mu: man man mm m mm mm m m mu: m mm mm mm mm mu m mm mm mm mm Wm mm: mm mm mm we mm m m mu mm mm mm m m max mm mm: mm mm mm mm m moo mm m m mu amen um mm mm m mm! mm mm mm was man mu m m mo: alum-7 m m\" m mm mu am mm mm m: m mm mm m mu: man mm m nu mu m mix as) mm mm am mm was um mm mm amen mm mm am we mm some new mm wow um mu m um mu! m man mm m a: mm mm m mu mm m mm m m mm m vow mm- m law mu um um mu mm mm mm m m m. a: no: a: mu mm mm mm m m mm: new we mm: m m mm m mm mm m m m: w m m mm: mm m m: m m m mam) mm m mam sum: m mam m mm mm m m mm mun um um am now mum 3m m mm am m mm 3314:): m mun m m mun: w m was man mu m. an: um mm. mm mm mm am m: m,\" m m ms): sum mm mm: same man mm mm m m: am we mm: um um mu m m n: mm: m mm mm. um Inc 201an m m mm mm m mm mm m mm mm m was .w my mm! 1mm m \f