1 MATH 123 –HW 4: Pie Chart, Descriptive Statistics & Weighted AverageName:_____________________ Part I: You need to submit the excel file for Problems 1 and 2 via the link provided in IvyLearn. Inserting Charts in Excel 1.The following data is from and breaks down Indiana’s households by type. Persons in Group Quarters 186,923 Families 1,674,126 Families with Children 746,717 Married Couples 1,241,267 Single Parents 249,247 Living Alone 671,920 Unmarried Partners 172,836 a.Open Excel and enter this data. b.Highlight your data and insert a pie-chart. c.Format your chart so that both the percent and labels for each type of householdare visible. d.Write a few observations on Indiana’s households.Excel for Descriptive Statistics 2.Professor Ivy has the following scores on her final exams: 97 88 66 55 89 72 94 32 84 89 Using Excel, find the mean, median, mode, 25thpercentile, 75thpercentile, maximum, minimum, and range. 72 76 77 Mean Median Mode 25thPercentile 75thPercentile Maximum Minimum Range

2 Part II: Show all work, include how problems were setup. Write answers using complete sentences when appropriate.