please answer the following questions given the information in the spreadsheets.

please show specific formulas for excel.

V # D Accounting $ % ) N 0 age Layout Formulas Data Review View Tell me Calibri (Body) 12 ~AA LO 2 Wrap Text Paste B TV a. Av Merge & Center L8 x fx AVERAGE("Price per Sq Ft 'IK14:23) A B D F G H K M 1 # Questions Answers 2 1 What is the median home price in Fresno in 2010? $137,500 3 2 What is the median home price in Fresno in 20222 $257,500 4 What is the overall percentage Increase for the entire regional market from 2010 to 2022? 5 4 What is the percentage increase for the Fresno Market only between 2010 and 2022? 6 S What is the percentage Increase for the Clovis Market only between 2010 and 2022? 7 6 Which city has the highest percentage Increase between 2010 and 2022. in home pricing? 8 2 What is the average sq ft increase in Frosno between 2010 and 2022? $ 105.30 9 8 Say you are looking for a 3 bedroom, 2-bath home in Fresno and you find one that is 1,380 square foot in 10 size. What do you expect to pay for it this year? 11 9 Assuming the housing market trend continues, what do you expect to pay for a house in Clovis, California, 12 in another 12 years from now if the house is currently priced at $150,000? 13 10 Look for a 3-bedroom, 2-bed house in another city anywhere in California or another state where you 14 would like to move at one point or another. What is the current cost of that home? 15 16 17 18 19 20 21 II = 12 Calibri (Body) V aste a. Av = = = 5 1 x fx =MEDIAN(114:23) B C D E F G Fresno/Clovis Home Prking Comparison Date: 02/18/2022 Address State Zip City Bed Bath SqFt Lot Size 2010 Price Gain 2022 Price 1 1422 Gisbon Ave Clovis ca 93611 2 1 864.00 9375 $80,000 $225,000 $145.000 22460 Joshu Ave Clovica 93611 3 22.217.00.28 Acre $350.000 $629.000 $279.000 3 2520 Argyle Ave Clovisca 93612 3 2 1.455.00 6500 $150.000 $355,000 $205,000 1363 Coventry Ave dovis 93511 3 2 1.349.00 6930 $140,000 $32,999 $248 999 5 548 N Amstrong Ave Clovisa 93511 3 11800.00 1.52 Acre $350,000 $700.000 $350,000 6547 W San Jose Ave Covis la 93612 3 21,336.00 6800 5135.000 $325,000 $190,000 71924 W San Gabriel Ave Clovis C 93612 3 21,288.00 6400 $135.000 $334,500 $199.500 8 390 Trenton Ave Clovis la 93619 3 2 2.290.00 37 Acre $340,000 $612 777 $277.277 2 92605 Donner Ave Clovis ca 93612 2 1 960.00 6000 $125.000 $289.000 $164.000 310 222 W Indianapolis Ave Clovis la 93612 3 2) 1.420.00 6405 $150,000 $340,000 $190,000 A 11 4707 N kavanagh Ave Fresno o 93705 3 211,217.00 6510 $150 000 $265.000 $115.000 1512 1515 5 3rd St Fresno o 93702 21 1 B00.00 7150 $120,000 $209,200 $89.200 16 13 3347 E Buckinham Way Fresno da 93726 3 22.309.00 6300 $135.000 $250,000 $115.000 17 14 3902 E Donner Ave Fresno Ca 93726 3 21 1.450.00 6600 $140.000 $250.000 $110.000 18 35 2223 N Varedes Ave Fresno CA 93705 3 21379.00 6300 $150,000 $349.990 $199,990 19 16 5839 E Andrew Ave Fresno Ca 93727 3 21.008.00 6500 $120.000 $265.000 $145.000 20 12 5567 N Lucy Puls Ave Fresno o 93723 4 3 2.029.00 8892 $250 000 S530.000 $280,000 21 13 4560 E Hamilton Ave Fretno 93702 4 1 748.00 7500 $100.000 $165.000 S65.000 22 19 577 E tower Ave Fresno lo 93705 4 1 1.132.00 8100 $135.000 $240.000 $105,000 23 20 4663 E Clinton Ave Fresno Ca 93703 3 15 1,732.00.27 Acre $177000 $309.900 $132.900 24 25 Total $3,432.000 5703,356 $3,606,366 26 27 Overal Pricing 28 Overall Highest Price $350,000 $700,000 $350.000 29 Overal Lowest Price $80,000 $165.000 $65.000 30 Overal Median Prke $140,000 5317,450 $177,000 31 Total Gains in market 53,606 366 32 33 Fresno 14 Highest Price In Fresno $250,000 $530,000 $280,000 35 Median Price in Fresno $137,500 $257.500 $115,000 36 Lowest Prke Fresno $100,000 $165,000 $65.000 ST Total Gains in Fresne 39 $1,157,090 19 Clovis 00 Michest Price in Cavid $350.000 41 Lowest Price in Covh 5700.000 $350,000 Sa0,000 42 Median Price in Clavi $225,000 $145.000 13 Total Gaima in Clovis S145.000 $347.500 $202,250 44 $2.149,275 45 46 4 41 4 Listing Formatted Listing Price per Sa Ft Homes increase Chart Ant Ready LO Paste BI U v V a. Av K30 XV fx =(J30-130) A B D E G H 1 2 F Fresno/Clovis Home Pricing Comparison Date: 02/18/2022 3 # Address City State Zip Bed Bath Sq Ft Price/Sq Ft 2010 Price/Sq Ft 2022 Increase 4 1 1422 Gisbon Ave Clovis Ca 93611 2 1 864.00 $ 92.59 260.42 $ 167.82 5 2 2460 Joshu Ave Clovis Ca 93611 3 22,717.00 $ 128.82 $ 231.51 S 102.69 6 33520 Argyle Ave Clovis ca 93612 3 2 1455.00 $ 103.09 $ 243.99$ 140.89 7 4 1363 Coventry Ave Clovis Ca 93611 3 21,349.00 $ 103.78$ 288.36 $ 184.58 8 5548 N Armstrong Ave Clovis ca 93611 3 1 1,600.00 $ 218.75 S 437.50 $ 218.75 9 6547 W San Jose Ave Clovis Ca 93612 3 2 1,336.00 $ 101.05$ 243.26 $ 142.22 10 2 924 W San Gabriel Ave Clovisca 93612 3 2 1,288.000 $ 104.81 259.70 $ 154.89 11 8 390 Trenton Ave Clovis ca 93619 3 2 2,290.00 $ 148.47 $ 269.77 $ 121.30 12 92605 Donner Ave Clovis Ca 93612 2 1 950.00 $ 130.21 $ 301.04 $ 170.83 13 10 722 W Indianapolis Ave Clovisca 93612 3 21420.00 $ 105.63 $ 239.44 $ 133.80 14 11 4707 N kavanagh Ave Fresno Ca 93705 3 2 1,217.00 $ 123.25$ 217.75 $ 94.49 15 12 15155 3rd St Fresno Ca 93702 2 1 800.00 $ 150.00 $ 261.50 $ 111.50 16 13 3347 E Buckinham Way Fresno Ca 93726 3 21,309.00 $ 103.13 S 190.99$ 87.85 17 14 3902 E Donner Ave Fresno Ca 93726 3 2 1.450.00 $ 96.55S 172.41 $ 75.86 18 15 2223 N Vagedes Ave Fresno Ca 93705 3 2 1,379.00 $ 108.775 253.80 S 145.03 19 16 5839 E Andrew Ave Fresno Ca 93727 3 21 1,008,00 S 119.05 IS 262.90 $ 143.85 20 17 5567 N Lucy Ruis Ave Fresno Ca 93723 4 32,029.00 $ 123.21s 261.21 $ 138,00 21 18 4560 E Hamilton Ave Fresno Ca 93702 4 1 748.00 $ 133.695 220.59 $ 86.90 22 19 577 E tower Ave Fresno Ca 93706 4 1 1,132.00 $ 119.265 212.01 S 92.76 23 20 4663 E Clinton Ave Fresno Ca 93703 3 1.5 1,732.00 $ 102.19 $ 178.935 76.73 24 25 Totals 2,416.325 5,007.07 $2,590.75 26 Totals Clovis Sq FtIncrease $1,537.78 27 Totals Fresno Sq FtIncrease $1,052.97 28 29 Average Se Ft in Clovis $ 123.72 $ 277.50 S 153.78 30 Average Sq Ft in Fresno $ 117.91 $ 223.21 $ 105.30 31 Averare Se Ft increase in Region $ 129.54 32 33 34 35 36 V # D Accounting $ % ) N 0 age Layout Formulas Data Review View Tell me Calibri (Body) 12 ~AA LO 2 Wrap Text Paste B TV a. Av Merge & Center L8 x fx AVERAGE("Price per Sq Ft 'IK14:23) A B D F G H K M 1 # Questions Answers 2 1 What is the median home price in Fresno in 2010? $137,500 3 2 What is the median home price in Fresno in 20222 $257,500 4 What is the overall percentage Increase for the entire regional market from 2010 to 2022? 5 4 What is the percentage increase for the Fresno Market only between 2010 and 2022? 6 S What is the percentage Increase for the Clovis Market only between 2010 and 2022? 7 6 Which city has the highest percentage Increase between 2010 and 2022. in home pricing? 8 2 What is the average sq ft increase in Frosno between 2010 and 2022? $ 105.30 9 8 Say you are looking for a 3 bedroom, 2-bath home in Fresno and you find one that is 1,380 square foot in 10 size. What do you expect to pay for it this year? 11 9 Assuming the housing market trend continues, what do you expect to pay for a house in Clovis, California, 12 in another 12 years from now if the house is currently priced at $150,000? 13 10 Look for a 3-bedroom, 2-bed house in another city anywhere in California or another state where you 14 would like to move at one point or another. What is the current cost of that home? 15 16 17 18 19 20 21 II = 12 Calibri (Body) V aste a. Av = = = 5 1 x fx =MEDIAN(114:23) B C D E F G Fresno/Clovis Home Prking Comparison Date: 02/18/2022 Address State Zip City Bed Bath SqFt Lot Size 2010 Price Gain 2022 Price 1 1422 Gisbon Ave Clovis ca 93611 2 1 864.00 9375 $80,000 $225,000 $145.000 22460 Joshu Ave Clovica 93611 3 22.217.00.28 Acre $350.000 $629.000 $279.000 3 2520 Argyle Ave Clovisca 93612 3 2 1.455.00 6500 $150.000 $355,000 $205,000 1363 Coventry Ave dovis 93511 3 2 1.349.00 6930 $140,000 $32,999 $248 999 5 548 N Amstrong Ave Clovisa 93511 3 11800.00 1.52 Acre $350,000 $700.000 $350,000 6547 W San Jose Ave Covis la 93612 3 21,336.00 6800 5135.000 $325,000 $190,000 71924 W San Gabriel Ave Clovis C 93612 3 21,288.00 6400 $135.000 $334,500 $199.500 8 390 Trenton Ave Clovis la 93619 3 2 2.290.00 37 Acre $340,000 $612 777 $277.277 2 92605 Donner Ave Clovis ca 93612 2 1 960.00 6000 $125.000 $289.000 $164.000 310 222 W Indianapolis Ave Clovis la 93612 3 2) 1.420.00 6405 $150,000 $340,000 $190,000 A 11 4707 N kavanagh Ave Fresno o 93705 3 211,217.00 6510 $150 000 $265.000 $115.000 1512 1515 5 3rd St Fresno o 93702 21 1 B00.00 7150 $120,000 $209,200 $89.200 16 13 3347 E Buckinham Way Fresno da 93726 3 22.309.00 6300 $135.000 $250,000 $115.000 17 14 3902 E Donner Ave Fresno Ca 93726 3 21 1.450.00 6600 $140.000 $250.000 $110.000 18 35 2223 N Varedes Ave Fresno CA 93705 3 21379.00 6300 $150,000 $349.990 $199,990 19 16 5839 E Andrew Ave Fresno Ca 93727 3 21.008.00 6500 $120.000 $265.000 $145.000 20 12 5567 N Lucy Puls Ave Fresno o 93723 4 3 2.029.00 8892 $250 000 S530.000 $280,000 21 13 4560 E Hamilton Ave Fretno 93702 4 1 748.00 7500 $100.000 $165.000 S65.000 22 19 577 E tower Ave Fresno lo 93705 4 1 1.132.00 8100 $135.000 $240.000 $105,000 23 20 4663 E Clinton Ave Fresno Ca 93703 3 15 1,732.00.27 Acre $177000 $309.900 $132.900 24 25 Total $3,432.000 5703,356 $3,606,366 26 27 Overal Pricing 28 Overall Highest Price $350,000 $700,000 $350.000 29 Overal Lowest Price $80,000 $165.000 $65.000 30 Overal Median Prke $140,000 5317,450 $177,000 31 Total Gains in market 53,606 366 32 33 Fresno 14 Highest Price In Fresno $250,000 $530,000 $280,000 35 Median Price in Fresno $137,500 $257.500 $115,000 36 Lowest Prke Fresno $100,000 $165,000 $65.000 ST Total Gains in Fresne 39 $1,157,090 19 Clovis 00 Michest Price in Cavid $350.000 41 Lowest Price in Covh 5700.000 $350,000 Sa0,000 42 Median Price in Clavi $225,000 $145.000 13 Total Gaima in Clovis S145.000 $347.500 $202,250 44 $2.149,275 45 46 4 41 4 Listing Formatted Listing Price per Sa Ft Homes increase Chart Ant Ready LO Paste BI U v V a. Av K30 XV fx =(J30-130) A B D E G H 1 2 F Fresno/Clovis Home Pricing Comparison Date: 02/18/2022 3 # Address City State Zip Bed Bath Sq Ft Price/Sq Ft 2010 Price/Sq Ft 2022 Increase 4 1 1422 Gisbon Ave Clovis Ca 93611 2 1 864.00 $ 92.59 260.42 $ 167.82 5 2 2460 Joshu Ave Clovis Ca 93611 3 22,717.00 $ 128.82 $ 231.51 S 102.69 6 33520 Argyle Ave Clovis ca 93612 3 2 1455.00 $ 103.09 $ 243.99$ 140.89 7 4 1363 Coventry Ave Clovis Ca 93611 3 21,349.00 $ 103.78$ 288.36 $ 184.58 8 5548 N Armstrong Ave Clovis ca 93611 3 1 1,600.00 $ 218.75 S 437.50 $ 218.75 9 6547 W San Jose Ave Clovis Ca 93612 3 2 1,336.00 $ 101.05$ 243.26 $ 142.22 10 2 924 W San Gabriel Ave Clovisca 93612 3 2 1,288.000 $ 104.81 259.70 $ 154.89 11 8 390 Trenton Ave Clovis ca 93619 3 2 2,290.00 $ 148.47 $ 269.77 $ 121.30 12 92605 Donner Ave Clovis Ca 93612 2 1 950.00 $ 130.21 $ 301.04 $ 170.83 13 10 722 W Indianapolis Ave Clovisca 93612 3 21420.00 $ 105.63 $ 239.44 $ 133.80 14 11 4707 N kavanagh Ave Fresno Ca 93705 3 2 1,217.00 $ 123.25$ 217.75 $ 94.49 15 12 15155 3rd St Fresno Ca 93702 2 1 800.00 $ 150.00 $ 261.50 $ 111.50 16 13 3347 E Buckinham Way Fresno Ca 93726 3 21,309.00 $ 103.13 S 190.99$ 87.85 17 14 3902 E Donner Ave Fresno Ca 93726 3 2 1.450.00 $ 96.55S 172.41 $ 75.86 18 15 2223 N Vagedes Ave Fresno Ca 93705 3 2 1,379.00 $ 108.775 253.80 S 145.03 19 16 5839 E Andrew Ave Fresno Ca 93727 3 21 1,008,00 S 119.05 IS 262.90 $ 143.85 20 17 5567 N Lucy Ruis Ave Fresno Ca 93723 4 32,029.00 $ 123.21s 261.21 $ 138,00 21 18 4560 E Hamilton Ave Fresno Ca 93702 4 1 748.00 $ 133.695 220.59 $ 86.90 22 19 577 E tower Ave Fresno Ca 93706 4 1 1,132.00 $ 119.265 212.01 S 92.76 23 20 4663 E Clinton Ave Fresno Ca 93703 3 1.5 1,732.00 $ 102.19 $ 178.935 76.73 24 25 Totals 2,416.325 5,007.07 $2,590.75 26 Totals Clovis Sq FtIncrease $1,537.78 27 Totals Fresno Sq FtIncrease $1,052.97 28 29 Average Se Ft in Clovis $ 123.72 $ 277.50 S 153.78 30 Average Sq Ft in Fresno $ 117.91 $ 223.21 $ 105.30 31 Averare Se Ft increase in Region $ 129.54 32 33 34 35 36