Question

Location	Square Footage	Rent per Month		Location	Square Footage	Rent per Month
Queens	500	650		Nassau County	1100	1875
Queens	588	1215		Nassau County	588	1075
Queens	1000	2000		Nassau County	1250	1775
Queens	688	1655		Nassau County	556	1050
Queens	825	1250		Nassau County	825	1300
Queens	460	1805		Nassau County	743	1475
Queens	1259	2700		Nassau County	660	1315
Queens	650	1200		Nassau County	975	1400
Queens	560	1250		Nassau County	1429	1900
Queens	1073	2350		Nassau County	800	1650
Queens	1452	3300		Nassau County	1906	4625
Queens	1305	3100		Nassau County	1077	1395

Project guidelines

1. Choose one of the spread sheets (there are 2 of them: male and female drivers, and Queens and Nas counties.)
2. Construct a combined bar graph with the data
3. Analyze the result.
4. Think of a scenario where a person can use the info from the graph
5. Find the mean, standard deviation variance, … for the data set

Graph: In Excel: highly all the data need, then click on insert – look for bar graph.

Answer 1

Combined bar graph for locationQueens:

Combined bar graph for location Nassau County:

In the location Queens, the each total square footage for rent ranges from 460 to 1452 and the rent per month per total square footage ranges from 650 to 3300.

In the location Nassau county, the each total square footage ranges from 556 to 1906 and the rent per month per total square footage ranges from 1050 to 4625.

If a person wants to take any space on monthly rental basis for housing or stocking or office or retail out let etc.. in the locations Queens and Nassau county then he may use the above data to understand the monthly rents per total square footage and he may go for selection based on his personal choice and viability..

For, the location Queens:

Mean of total Square footage = (500+588+…+1305)/12 =863.33

Variance of total Square footage=[(5002+5882+…+13052)/12] - 863.332 =108418.22

Standard deviation of total Square footage=Sqrt(108418.22) = 329.26

Mean of monthly rent per total Square footage = (650+1215+…+3100)/12 =1872.92

Variance of monthly rent per total Square footage=

[(6502+12152+…+31002)/12] - 1872.922 =639956.07

Standard deviation of monthly rent per total Square footage=Sqrt(639956.07) = 799.97

For, the location Queens:

Mean of total Square footage = (500+588+…+1305)/12 =863.33

Variance of total Square footage=[(5002+5882+…+13052)/12] - 863.332 =108418.22

Standard deviation of total Square footage=Sqrt(108418.22) = 329.26

Mean of monthly rent per total Square footage = (650+1215+…+3100)/12 =1872.92

Variance of monthly rent per total Square footage=

[(6502+12152+…+31002)/12] - 1872.922 =639956.07

Standard deviation of monthly rent per total Square footage=Sqrt(639956.07) = 799.97

For, the location Nassau county:

Mean of total Square footage = (1100+588+…+1077)/12 =992.41

Variance of total Square footage=[(11002+5882+…+10772)/12] - 992.412 =141866.24

Standard deviation of total Square footage=Sqrt(141866.24) = 376.65

Mean of monthly rent per total Square footage = (1875+1075+…+1395)/12 =1736.25

Variance of monthly rent per total Square footage=

[(18752+10752+…+13952)/12] – 1736.252 =831133.85

Standard deviation of monthly rent per total Square footage=Sqrt(831133.85) = 911.66