Business Descriptive Statistics Worksheet

Business Descriptive Statistics Worksheet

Business Descriptive Statistics Worksheet

Descriptive Statistics – I have 9 different multiple choice questions and need them answered while showing work/ how it is done. The word document provides the questions and the excel document provides all the numbers needed to answer the following questions. Business Descriptive Statistics Worksheet

BANA 2010, Business Statistics, Fall 2020

 

Instructions.

 

All questions are multiple choice.

 

Submit answers through Canvas on or before the due date.  No answers are accepted after the due date.  If no answers are submitted by the due date, the grade will be zero.

 

Take care and note that answers through Canvas may only be submitted once.  Therefore, download the Word file with the questions.  Obtain all the answers.  Then submit all your answers only once through Canvas.

 

  Support Material  
Support for this assignment includes material at the website: MDHarper.com

At the MDHarper.com website, click the “Business Statistics” tab.

. . .

 

  Support Material  
Support for this assignment includes material in the textbook-1, Introduction to Business Statistics

Consider the material in Chapter 2.

I cover material that the textbook does not cover and the textbook covers material I do not.

The lecture will cover the key material for this course.

. . .

 

Descriptive Statistics
Graphs *Dotplot Numerical

*Histogram

*Stem and Leaf

*Box and Whiskers

 

Categorical

*Bar chart

*Pareto chart

*Pie chart

 

Time Series

*Line chart

*Control chart

 

Multivariate

*Scatter plot

*Radar chart

*Frequency Distribution

*Probability Distribution

*Probability Density Function (pdf)

*Probability Distribution Function (PDF)

Measures Central Tendency

*Mean

*Median

*Mode

 

Dispersion

*Range

*Variance

*Standard Deviation

*Percentiles

 

*Skewness

 

*Kurtosis Bivariate

Covariance

Correlation

Regression

 

 

 

 

Part 1. [Definitions]

 

Question 1.

How many statements are correct?   0  1  2  3  4  5  6  7  8

Statement A. For a random variable, X, that follows a probability distribution, P(X), the mean is given by SX*X*P(X).

Statement B. The expectation of a random variable is the same as the mean of a distribution.

Statement C. The standard deviation is the square root of the variance.

Statement D. The mean, median, and mode is a measure of dispersion whereas range, standard deviation and variance is s measure of central tendency.

Statement E. The mean=median=mode for a symmetric distribution.

Statement F. For a positively skewed distribution, the mean<median<mode.

Statement G. For a skewed left distribution, the mean>median>mode.

Statement H. A skewed left distribution is the same as a positively skewed distribution.

. . .

 

Question 2.

How many statements are correct?   0  1  2  3  4  5  6  7  8

Statement A. A Histogram displays frequency content of aggregate numerical data.

Statement B. A Stem and Leaf displays data points as the frequency content of aggregate numerical data.

Statement C. A Box and Whiskers Plot displays Max, Min, first, second, and third quartiles.

Statement D. A Bar Chart displays frequency content of categorical data rank ordered by frequency.

Statement E. A Pareto Chart displays frequency content of categorical data.

Statement F. A Pie Chart displays relative frequency content of categorical data.

Statement G. A Radar Chart displays multiple variables.

Statement H. A Scatter Plots displays relationship between two numerical variables.

. . .

 

Part 2. [ Box-and-Whiskers Plot ]

 

For questions 3 and 4, consider the box-and-whiskers plot.

 

+
0 1 2 3 4 5 6 7 8 9

. . .

Question 3.

Which statement correctly interprets the box-and-whiskers plot?

Statement A. The median is 5, Q1=4, Q3=7, Min=0, Max=9.

Statement B. The median is 6, Q1=4, Q3=10, Min=2, Max=16.

Statement C. The median is 6, Q1=4, Q3=7, Min=1, Max=8.

Statement D. The median is 8, Q1=2, Q3=16, Min=0, Max=18.

Statement E. None of the above

. . .

Question 4.

How many statements are correct from the box-and-whiskers plot?  0  1  2  3  4  5  6  7  8

Statement A. The distribution is negatively skewed

Statement B. The range is 9

Statement C. The first quartile is 1

Statement D. The 75th percentile is 8

Statement E. The median is 6

Statement F. The interquartile range is 7

Statement G. The mean is greater than 6

Statement H. The distribution is skewed right

. . .

 

Part 3. [ Stem-and-Leaf Plot ]

 

For questions 5 and 6, consider the stem-and-leaf plot.

 

Freq Stem Leaf=1
1 1 2
2 1 8
(3) 2 123
2 2
2 3 4
1 3
1 4 3

. . .

Question 5.  Which set of data is correct for this stem-and-leaf plot?

A. (11,21,32,22,23,13,14)

B. (12,18,21,22,23,34,43)

C. (2,8,1,2,3,4,3)

D. (120,180,210,220,230,340,430)

E. None of the above

. . .

Question 6.  How many statements are correct from stem-and-leaf plot?   0  1  2  3  4  5  6  7

Statement A. Median 21

Statement B. Q1=11

Statement C. Q3=43

Statement D. The interval is 5

Statement E. Sample size is 7

Statement F. The range is 31

Statement G. The distribution is skewed right.

. . .

 

Part 4. [ Histograms ]

 

For questions 7 and 8, consider the histograms.

 

Question 7.  Which set of data is correct for this histogram?

A. (15,21,24,25,26,30,35,38,49)

B. (13,20,22,24,26,28,35,36,45)

C. (12,21,24,26,28,29,35,40,50)

D. (13,20,22,25,26,28,35,36,45)

E. None of the above

.

Histogram
Intervals 0 1 2 3 4 5
10 to 15
15 to 20
20 to 25
25 to 30
30 to 35
35 to 40
40 to 45
45 to 50

. . .

Question 8.  What is the mean from the histogram?

A. 11.0    B. 9.5   C. 8.5   D. 7.8   E. None of the above

Histogram
Intervals 0 1 2 3 4 5 6
0 to 2
2 to 4
4 to 6
6 to 8
8 to 10
10 to 12
12 to 14
14 to 16

. . .


 

 

Question 9. (2 points)

Upload one PDF file with three graphs using the data from the spreadsheet provided through the link in Canvas of the data file of the “2016 Individual Income Tax Returns (Full-Year Residents)”.

In the data file, select one county in Colorado and upload three graphs, one graph on each page.

Graph 1)  A histogram of the “Federal Taxable Income”

Graph 2)  A histogram of the “Federal Tax”

Graph 3)  A line chart of the “Federal Taxable Income” and the “Federal Tax” together.

In the Excel data file, find information similar to these headings for a particular county:

Size of Federal AGI Federal
Taxable
Income
Federal
Tax
$ 0 to $ 9,999 54465 30657
$ 10,000 to $ 19,999 773554 131460
$ 20,000 to $ 29,999 2263206 279410
$ 30,000 to $ 39,999 3700622 452060
$ 40,000 to $ 49,999 4392676 549480
$ 50,000 to $ 59,999 4636613 623610
$ 60,000 to $ 74,999 7030617 1014490
$ 75,000 to $ 99,999 11534054 1721997
$ 100,000 to $ 199,999 30919958 5462115
$ 200,000 to $ 499,999 22274839 5341317
$ 500,000 to $ 999,999 8049793 2418301
$ 1,000,000 and over 16245879 4995068

Your graphs for a county you select should look like these:

. . .

>>>End of Homework<<<