6) The data in found in height-data-a6.xlsx represents the heights of randomly selected individuals in centimeters, from
Question:
6) The data in found in height-data-a6.xlsx represents the heights of randomly selected individuals in centimeters, from 25 cities. For example, the first city, x1, has its sample data as 173cm, 201cm, 175cm, 166cm, 189cm, 153cm and 143cm. The study is focuses on 25 cities, which means each sample xi corresponds to the ith city. We are interested in finding whether the population height of at least one city is significantly different than the rest of the cities. Use Excel to determine whether there exist at least one anomaly1 from the cities collected. Use = 0.05 as the level of significance. The Excel sheet is a read-only file that is accessed onlinew. You need to copy/paste all the data into a new Excel file that you create. There must not be duplication of numbers (e.g., the Sample Size (ni) column should have one and only one value, not the same value copied/pasted several times). The yellow highlighted cells need to be filled in. Please don't change the layout and only fill in the yellow highlighted cells only along with the conclusion at the end. Heavy, very heavy, penalty will be applied for value duplication or layout change. No need to include the null/alternative hypotheses, just the conclusion.