Calculate Statistical Measures Using Excel Use Excel to produce graphs and calculate some statistical measures. Introduction . . . problems create value; the m

Use Excel to produce graphs and calculate some statistical measures.

Introduction

. . . 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.

Overview

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.

Preparation

Follow these steps to prepare for this assessment:

Download 

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 

Writing Process
 page for an overview of the writing process. Following each of these stages will help you write a strong, clear, and organized presentation.

You may see the