Question

The number of weekly sales calls by a sample of 25 pharmaceutical salespersons is below. 24,...

The number of weekly sales calls by a sample of 25 pharmaceutical salespersons is below. 24, 56, 43, 35, 37, 27, 29, 44, 34, 28, 33, 28, 46, 31, 38, 41, 48, 38, 27, 29, 37, 33, 31, 40, 50 What is the shape of the distribution of the data?

please expalin how you use this on excel in step by step

Homework Answers

Answer #1

Step 1 : Enter data in excel in a single column

Step 2 : calculate five number summary for that use function

Minimum = QUARTILE.INC(data range, 0)

Quartile 1 =QUARTILE.INC(datarange,1)

Quartile 2 =QUARTILE.INC(datarange,2)

Quartile 3 =QUARTILE.INC(datarange,3)

Maximum =QUARTILE.INC(datarange,4)

So we get excel output

Therefore,

We get

Q3 - Q2 = 6

Q2 - Q1 = 6

We get

Q3 -Q2 = Q2 - Q1

Hence shape of distribution is symmetric distribution.

Thank you!

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Dataset: Husband   Wife 53   50 38   34 46   44 30   36 31   23 26   31 29  ...
Dataset: Husband   Wife 53   50 38   34 46   44 30   36 31   23 26   31 29   25 48   51 65   46 29   26 28   23 29   32 25   22 22   21 21   24 43   50 24   27 38   33 33   26 35   29 40   29 27   25 27   24 49   38 48   39 27   27 26   24 40   34 35   37 21   26 32   39 30   28 60   52 36   40 25   23 66   55 52   34 41   40 43  ...
2. In a country called Karpee's Nation, Sixty (60) persons were asked about their ages in...
2. In a country called Karpee's Nation, Sixty (60) persons were asked about their ages in completed years and they responded as follow: 34 34 40 42 40 42 29 30 28 44 25 37 37 42 29 33    34 29 43 41 25 40 37 33 32 37 40 51 28 27 31 64    38 40 30 41 51 30 48 24 28 33 35 40 31 29 35 46 27 34 28 29 35 30 29...
B. Determine whether or not the table is a valid probability distribution of a discrete random...
B. Determine whether or not the table is a valid probability distribution of a discrete random variable. Explain fully. X 0.23 0.14 0.17 P(X=x) -0.22 0.38 0.84 Daily sales of a medium sized restaurant are normally distributed with a mean of $720 and a standard deviation of $80. What is the probability that a randomly selected day will make a sales of at least $656? What is the probability that a randomly selected day will make a sales between $680...
Cholesterol levels: A national health survey measured the serum HDL cholesterol levels in a large number...
Cholesterol levels: A national health survey measured the serum HDL cholesterol levels in a large number of women. Following is a sample of 37 HDL levels (in milligrams per deciliter) that are based on the results of that survey. The list has been sorted into numerical order. 25 25 25 26 27 27 27 28 28 29 34 35 35 38 38 39 42 42 43 44 45 45 45 45 46 46 47 48 51 52 56 57 65...
The table below lists the earnings (in thousands of dollars) of a random sample of 10...
The table below lists the earnings (in thousands of dollars) of a random sample of 10 male and 10 female salespersons. At alpha = 0.10 can you conclude that there is a difference between males’ and females’ earnings? Male 28 43 64 51 48 44 36 45 67 49 Female 36 27 51 43 35 48 41 37 34 47 The claim is “there is a difference between males’ and females’ earnings”. Worked this by hand!!
descriptive statistics for the given data 4 8 18 20 21 22 23 24 25 26...
descriptive statistics for the given data 4 8 18 20 21 22 23 24 25 26 27 28 29 30 31 31 32 32 33 33 34 35 36 37 38 39 47 53
. Studies are often done by pharmaceutical companies to determine the effectiveness of a treatment program....
. Studies are often done by pharmaceutical companies to determine the effectiveness of a treatment program. Suppose that a new AIDS antibody drug is currently under study. It is given to patients once the AIDS symptoms have revealed themselves. Of interest is the average length of time in months patients live once starting the treatment. Two researchers each follow a different set of 40 AIDS patients from the start of treatment until their deaths. The following data (in months) are...
Studies are often done by pharmaceutical companies to determine the effectiveness of a treatment program. Suppose...
Studies are often done by pharmaceutical companies to determine the effectiveness of a treatment program. Suppose that a new AIDS antibody drug is currently under study. It is given to patients once the AIDS symptoms have revealed themselves. Of interest is the average length of time in months patients live once starting the treatment. Two researchers each follow a different set of 40 AIDS patients from the start of treatment until their deaths. The following data (in months) are collected....
weeks 39 42 37 41 39 38 37 35 38 37 45 42 40 38 38...
weeks 39 42 37 41 39 38 37 35 38 37 45 42 40 38 38 40 40 24 40 37 39 40 39 40 38 38 39 40 39 38 42 36 29 29 35 35 31 42 38 41 43 41 40 38 37 38 41 40 40 38 40 40 42 41 37 39 40 38 39 41 40 39 39 37 41 40 38 44 41 37 36 33 30 36 33 39 39 40 40...
Given the following companies sales of 4 brands below Microsoft Apple Alibaba Huawei 41 35 48...
Given the following companies sales of 4 brands below Microsoft Apple Alibaba Huawei 41 35 48 40 45 52 32 37 46 53 41 43 35 30 24 26 28 31 33 27 36 35 27 25 Considering n = 24 and α = 0.05. a) Write the Null hypothesis b) Write the Alternative hypothesis c) Use the analysis of variance to calculate the F-test d) Make a statistic decision about the Null hypothesis