Calculate Statistical Measures Using Excel
Use Excel to produce graphs and calculate some statistical measures.
. . . problems create value; the more problems you can solve, the more valuable you will be, the more money you will make, the more responsibility you will have.
â€“ Brian Klemmer, author and speaker
If you’ve ever played fantasy football, you know the importance of using player statistics orÂ
statsÂ like sacks and fumbles to plan your perfect team. But statistics play an important role in mathematics as well. Statistics is the process of taking large amounts of numerical data (such as from a football player’s track record), analyzing that data, and using it to solve problems (such as which player you should play and when). And it isn’t just for the football fan. In almost every field, from biology or business to psychology or math, understanding statistics helps professionals solve problems and make decisions.
Learning to add strategies to your problem-solving techniques will help you multiply your success at school, work, and home. In the workplace, problem-solving strategies can help you interact with customers, peers, and clients, meet deadlines, and even reach leadership or management positions. And in your personal life, they can help you alleviate stress, overcome relationship challenges, and achieve your goals.
In this assessment, you will use data on car prices to create charts in Excel and calculate statistical measures from the data. The data is provided inÂ
Auto Data [XLSX]
. It contains information on 82 used cars that are for sale, specifically, the asking price, the model year, the mileage, the color, and the trim.
Follow these steps to prepare for this assessment:
Auto Data [XLSX]
For information onÂ how to create a bar chart, pie chart, and scatterplotÂ charts, you can review pages 264â€“267 of the textbook.
For information on how to calculate the mean, median, standard deviation, and proportion,Â you can review pages 271â€“290 of the textbook.
Below are some resources to assist with writing your summary:
You may wish to review Capella’sÂ
Â page for an overview of the writing process. Following each of these stages will help you write a strong, clear, and organized presentation.