GB 310 lester Exam 2 Lester

For the remaining questions use the "FinalSales_data". How many rows are in this dataset excluding headers

1240

How many people are from Chicago in these data?

200

How many cities are in the workbook?

5

Which of the following excel formal calculated the average correctly in excel?

=Average(80,90,100)

Which person from Akron is the best salesperson (has the highest average sales across the month)?

Akron4

Which type of chart would you use if you wanted to get an idea about distribution of a single variable including outliers?

Box and Whisker Chart

Which of the following months had the highest average profit

February

What is the difference between sorting and filtering the data?

Filtering removes or hides data and sorting reorders the data

What is the primary reason for filtering your data?

Filtering the data makes it easier to see trends in the subset of interest

What is the significance of the total row?

It makes it easy to calculate various statistics for the columns

What type of chart is an effective way of displaying trends over time for different companies?

Line Charts

Which of the following is not a calculation preformed by excel?

Minimum()

Which person had the most sales in April?

NY634

Which city has the highest average sales in October?

New York

Which city has the most number of people in it?

New York

Are there any seasonal trends in terms of the sales data?

No, the mean always stays approximately equal to 111

How do you toggle between absolute and relatively referencing a cell?

Press F4

Scatter plots are in effective way to describe the relationship between two quantitative variables?

True

There are functions designed to format and modify text.

True

How can you tell that these data are formatted as a table?

when you click in the data range the Design Tab becomes Visible