In this project, you will use what you have learned in chapter 8 to analyze various high school data from each state in 2013-14. You should thoroughly review the Excel lesson posted in this module before taking on this project.

test

This is an individual assignment, though I encourage you to form a study group with some of your peers and complete this project together. I know that some of you prefer working alone and that is fine. Each student will anyhow upload their work individually; now, if you worked as part of a group, please list the names of your collaborators in the Canvas comment box after you upload your file. Download the Excel workbook file "Data Analysis - High School Data." Download "Data Analysis - High School Data."Use it to answer the questions as listed in each Excel sheet. You will complete all calculations, answer all questions and create the graphs needed in the Excel file.

When creating graphs, make sure all graphs include chart titles, axis titles, and a key. Remember, your graphs should be able to stand alone without the need for additional information in order to be understood.

Part 1: Completion Rates 1 Locate the completion rate data for each state on the "Completion Rate by State" tab. Calculate the mean, median, mode, maximum, minimum, range, and standard deviation for the completion rates. Use Excel formulas to calculate the values. 2 Using a minimum of five sentences, explain what the statistics calculated in the previous question tell you about the high school completion rates in 2013-14. Type your answer in the box provided on the Excel file. 3 Create a grouped frequency distribution for the completion rate data. The first class should start at 60; use a class width of 5. Fill in the grouped frequency distribution in the excel file. 4 Create a histogram based on the grouped frequency distribution you created. Insert the graph on the excel file in the provided space. Be sure to use the bar chart and change the gap width. 5 Using a minimum of three sentences, explain what the histogram tells you about high school completion rates in 2013-14.

Part 2: Average Teacher's Salary 1 Locate the average teacher's salary data for each state on the "Average Teacher's Salary" tab. Calculate the mean, median, mode, maximum, minimum, range, and standard deviation for the average teacher's salary data. Use Excel formulas to calculate the values. 2 Using a minimum of five sentences, explain what the statistics calculated in the previous question tell you about the average teacher's salary in 2013-14. Type your answer in the box provided on the Excel file. 3 Create a bar and pie graph using the average teacher's salary data by state. Insert these graphs in the provided space. 4 Using a minimum of five sentences, first, compare and contrast the graphs from question 3 and then explain the strengths and weaknesses of each graph. Which graph portrays the data better? Why?

Part 3: Pupil/Teacher Ratio 1 Locate the sheet, "Pupil-Teacher Ratio" and create a grouped frequency distribution for the pupil/teacher ratio. The first class should start with 8 and use a class width of 2. Because the data values include decimals, upper class limits will need to include a decimal value rather than be a whole number. 2 Create a histogram based on the grouped frequency distribution you created. Insert the graph on the excel file in the provided space. Be sure to use the bar chart and change the gap width.

3 Using a minimum of three sentences, explain what the histogram tells you about high school pupil/teacher ratios in 2013-14.

Part 4: Expenditure Per Student 1 Locate the sheet, "Expenditure Per Student". Calculate the mean, median, mode, maximum, minimum, range, and standard deviation for the expenditure per student data. Use Excel formulas to calculate the values. 2 Using a minimum of five sentences, explain what the statistics calculated in the previous question tell you about the high school expenditure per student in 2013-14. Type your answer in the box provided on the Excel file. 3 Create a bar graph using the expenditure per student data by state. Insert the graph in the provided space. 4 Using a minimum of three sentences, explain what the bar graph tells you about expenditure per student in 2013-14.

Part 5: Average Teacher's Salary by Region 1 Locate the sheet, "Avg Teacher's Salary Per Region". Use the data in the table titled Average Teacher's Salary by Region to create a line, side-by-side column, and stacked column graph where the years (2013-14, 2018-19) are represented on the horizontal axis. Insert the graphs in the provided space. 2 Compare the line, side-by-side column and stacked column graphs from the previous question. Using a minimum of five sentences, first, compare and contrast the graphs and then explain the strengths and weaknesses of each graph. Type your answer in the box provided on the excel file. 3 Create a line, side-by-side column, and stacked column graph where the regions (West, Midwest, Southwest, Southeast, Northeast) are represented on the horizontal axis. Insert the graphs in the provided space. 4 Compare the line, side-by-side column and stacked column graphs from the previous question. Using a minimum of five sentences, first, compare and contrast the graphs and then explain the strengths and weaknesses of each graph. Type your answer in the box provided on the excel file. 5 Compare the line, side-by-side column and stacked column graphs from questions 1 and 3. Using a minimum of three sentences, explain which graphs best visually display the average teacher's salary by region for the two years to provide the viewer with the most information and why. Type your answer in the box provided on the excel file.

Part 6: Data by Region 1 Locate the sheet, "Data by Region". Use the data in each table to make a bar graph for each table (you will have four separate bar graphs). Insert the graphs in the provided space. 2 Compare the Average Completion Rate by Region bar graph to each of the other bar graphs. Do you notice any trends in average completion rate based on average teacher's salary, average pupil/teacher ratio or average expenditure per student? Explain using a minimum of three sentences. Type your answer in the box provided on the excel file. (We will learn about linear regression and correlation in the next section of chapter 8. We will come back to this data to determine whether there is significant correlation between any of these variables and completion rate.)

test

Putting it All Together

Create an Infographic that summarizes the information you have learned from your analysis in this project to pass out to others. An infographic is graphic visual representations of information, data, or knowledge intended to present information quickly and clearly. Make sure to include information from each of Parts 1 - 6. You can use www.piktochart.comLinks to an external site., www.canva.comLinks to an external site., or go to https://www.creativebloq.com/infographic/tools-2131971 Links to an external site.for other websites that offer free infographic tools. Examples of infographics can be found in the Data Analysis Project module on Canvas. You will create an new sheet in your Excel file, labeled 'Infographic', and use the 'Insert Picture' feature in Excel to add your infographic in that sheet.

Once you have completed your work in all Excel sheets (total # of sheets = 7), save your work and upload it in Canvas. If you collaborated with some of your former group peers, please list their names in the comment box in Canvas.