Hi, can someone please help me with finding the right excel formulas for these problems?
5 6 170 320 3 Question 1: Renton Condominium Price Data (Zillow, 2018) Selling Price House Size Number of Number of Formulas entered at left will 4 ($000) (sq. ft) Bedrooms Bathrooms automatically appear 220 880 21.5 A. Selling Price Mean 263.08 =AVERAGE(AS:A29) 135590 7 225 880 2121 B. Price Std. Deviation 107.292 =STDEV(AS:A29) 225840 2801 1510 C. Are there any price outliers according to the "3 standard deviations from the mean" rule? 2151 915 205 900 C1. Lower Outlier Limit #N/A 590 225 1040 C2. Upper Outlier Limit #N/A 1070 149 590 C3. What do you conclude about price outliers in this data set? Identify any outliers. 980 It can be concluded that only one datum (price) can be considered as an outlier that exceeds 700 1580 the upper limit, and no data point exist as an outlier that extends beyond the lower limit. 300 14501 235 950 1130 320 1170 D. Condominium Price Data Distribution 1130 01. Fill in the table below with a class width of 65 (can be doen either with formulas or a pivot table) 2101 820 1060 Classes Count Rel. Freq. 2651 835 135-199 238 1130 2851 940 650 210 920 395 2961 275 32 33 Total D2. Histogram - Use Excel's graphing tools to create a properly formatted and fully labeled histogram Size graph to fit blue box M formula: N/A 54 Question 2: Regular Gas Average Prices for a sample of the Western Half of US States - July 2018 55 (https://gasprices.aaa.com/state-gas-price-averages/) 56 Alaska (Formulas display automatically) 57 Arizona 58 California 2a. Mean of Listed Prices formula: #N/A 59 Colorado 60 Hawaii 2b. Standard Deviation formula: #N/A 61 Idaho 62 Kansas 2c. What is the z-score for Washington's gas price value? 63 Montana Z-score: formula: #N/A 64 Nebraska $2.74 65 Nevada $3.24 2d. Interpret the z-score that you calculated - what does the z-score tell you about Washington's gas prices? 66 New Mexico $2.85 67 North Dakota $2.86 68 Oklahoma $2.62 69 Oregon $3.32 70 South Dakota $2.87 2e. Identify the elements of the 5 number summary and calculate them 71 Texas $2.66 Name Value Formula 72 Utah $3.14 #N/A 73 Washington $3.44 #N/A 74 Wyoming $2.97 #N/A 75 #N/A 76 #N/A 77 78 80 Question 3. Work Week Scheduling Preferences 81 Preference Male (M) Female (F) A. Write out in words the meaning of the probability statements, then calculate them, show your work 82 Four days (4) 300 600 A1. PIF) 83 Five days (5) 1,200 1,500 84 Flexible (Flex) 300 2,100 Calculated value 87 Fill in the green boxes as needed. 88 89 A2.P( 5M) 90 Calculated value #N/A 94 5 6 170 320 3 Question 1: Renton Condominium Price Data (Zillow, 2018) Selling Price House Size Number of Number of Formulas entered at left will 4 ($000) (sq. ft) Bedrooms Bathrooms automatically appear 220 880 21.5 A. Selling Price Mean 263.08 =AVERAGE(AS:A29) 135590 7 225 880 2121 B. Price Std. Deviation 107.292 =STDEV(AS:A29) 225840 2801 1510 C. Are there any price outliers according to the "3 standard deviations from the mean" rule? 2151 915 205 900 C1. Lower Outlier Limit #N/A 590 225 1040 C2. Upper Outlier Limit #N/A 1070 149 590 C3. What do you conclude about price outliers in this data set? Identify any outliers. 980 It can be concluded that only one datum (price) can be considered as an outlier that exceeds 700 1580 the upper limit, and no data point exist as an outlier that extends beyond the lower limit. 300 14501 235 950 1130 320 1170 D. Condominium Price Data Distribution 1130 01. Fill in the table below with a class width of 65 (can be doen either with formulas or a pivot table) 2101 820 1060 Classes Count Rel. Freq. 2651 835 135-199 238 1130 2851 940 650 210 920 395 2961 275 32 33 Total D2. Histogram - Use Excel's graphing tools to create a properly formatted and fully labeled histogram Size graph to fit blue box M formula: N/A 54 Question 2: Regular Gas Average Prices for a sample of the Western Half of US States - July 2018 55 (https://gasprices.aaa.com/state-gas-price-averages/) 56 Alaska (Formulas display automatically) 57 Arizona 58 California 2a. Mean of Listed Prices formula: #N/A 59 Colorado 60 Hawaii 2b. Standard Deviation formula: #N/A 61 Idaho 62 Kansas 2c. What is the z-score for Washington's gas price value? 63 Montana Z-score: formula: #N/A 64 Nebraska $2.74 65 Nevada $3.24 2d. Interpret the z-score that you calculated - what does the z-score tell you about Washington's gas prices? 66 New Mexico $2.85 67 North Dakota $2.86 68 Oklahoma $2.62 69 Oregon $3.32 70 South Dakota $2.87 2e. Identify the elements of the 5 number summary and calculate them 71 Texas $2.66 Name Value Formula 72 Utah $3.14 #N/A 73 Washington $3.44 #N/A 74 Wyoming $2.97 #N/A 75 #N/A 76 #N/A 77 78 80 Question 3. Work Week Scheduling Preferences 81 Preference Male (M) Female (F) A. Write out in words the meaning of the probability statements, then calculate them, show your work 82 Four days (4) 300 600 A1. PIF) 83 Five days (5) 1,200 1,500 84 Flexible (Flex) 300 2,100 Calculated value 87 Fill in the green boxes as needed. 88 89 A2.P( 5M) 90 Calculated value #N/A 94
