The number of sales calls by a sample of 25 pharmaceutical salespersons are provided in the table below: Weekly Sales Calls 40 56 43 35 37 27 29 44 34 28 33 28 46 31 38 41 48 38 27 29 37 33 31 40 50 Use Excel to compute, and then explain the summary descriptive statistics (e.g., mean, median, mode, range, standard deviation, etc.) for the number of weekly sales calls for this sample. Use Excel to construct a frequency histogram of the data set. Comment on the shape of the frequency distribution and briefly discuss the new information that the chart provides (e.g., kurtosis, skew, shape, etc.). Submit your Excel file.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 4AGP
icon
Related questions
Question

The number of sales calls by a sample of 25 pharmaceutical salespersons are provided in the table below: Weekly Sales Calls 40 56 43 35 37 27 29 44 34 28 33 28 46 31 38 41 48 38 27 29 37 33 31 40 50 Use Excel to compute, and then explain the summary descriptive statistics (e.g., mean, median, mode, range, standard deviation, etc.) for the number of weekly sales calls for this sample. Use Excel to construct a frequency histogram of the data set. Comment on the shape of the frequency distribution and briefly discuss the new information that the chart provides (e.g., kurtosis, skew, shape, etc.). Submit your Excel file. 

 

 

I need typed answer with explanation D

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL