Question

please anyone can help me with stastistic

1. Average Age of Houses a. Use the table below to plot an Excell Bar chart of the Ages of Houses in the Yookas District b. How many houses are in this district? c. Use the information to calculate the Average Age of Houses in the District Table I Age Distribution of Houses MF Mid Point Age of Houses Yonkas 0-25 years 25 to 35 years135,000 35 to 55 years 265,000 55 to 75 years|400,000 100,000 2. You have been provided data on unemployment in two regions. Use MS-Excel and the data to determine which region has the highest rate of unemployment. Please show your work and explain your results. Anglia Region Size of County Unemployment Workforce Woodie 4.2 120,000 Eaurest 5.6 40,000 Water 60,000 8.5 Sakzon Region Size of County Unemployment Workforce Weandy Stodbnie |Harkaine 3.5 100,000 12.5 40,000 6.4 80,000 After you complete your assignments Word and upload the MS-Word and the MS-Excel files Excel, copy your MS-Excel results into MS- on

Answer 1

P C D G J M N A C Age of Houses in years Yonkas Midpoint ME 1 Midp 100,000 1 Age of Houses in years Yonkas 2 0-25 3 25-35 4 35-55 5 55-75 Yonkas 2 0-25 100.000 12.5 100,000 450,000 135.000 3 25-35 30 135,000 135.000 400,000 4 35-55 265,000 45 265,000 265.000 350,000 400.000 5 55-75 65 400.000 400,000 300,000 6 6 250,000 7 7 200,000 8 8 150,000 CHARTS FORMATTING ТОTALS 9 Anglia Region 9 Anglia Regio 10 County 11 Woodie 12 Fourest 13 Water 14 Geometricn 100,000 10 County % umemployment Size of workforce 50,000 11 Woodie 4.2 120,000 12 Fourest 5.6 40,000 0-25 25-35 35-55 55-75 Clustere. Pie Clustere... Mo 13 Water 8.5 60,000 14 Geometric mean 5.847255634-GEOMEAN(B11:B13) ME 15 Recommended Charts help you visualize c 15 450,000 16 Sakzon Region 400,000 % umemployment Size of workforce 17 County 350.000 18 Weandy 19 Storhmie 20 Horkaine 3.5 100.000 300.000 12.5 40.000 250.000 6,4 80.000 200,000 21 Geometric mean 6.54213262 -GEOMEAN(B18:B20) 150,000 22 100 000 Sakzon region with the geometric mean of the % 50,000 unemployment is 6.5421 higher than the Anglia region. So 0 Sakzon has the highest rate of unemployment %. 23 12.5 30 45 65