Question

Excel Homework #1 1. A researcher is interested in describing the distribution of blood types. She...

Excel Homework #1


1. A researcher is interested in describing the distribution of blood types. She selects a random sample of forty patient files in an immediate care clinic and records the blood type on each. The data is shown:

        A; B; O; A; AB; O; O; A; O; B; A; A; A; O; O; O; B; O; AB; B

        O; B; O; AB; B; O; O; A; O; B; A; O; A; O; A; A; B; O; A; AB   

     a) Make a frequency table for this data.
     b) Make a pie chart for the data.
    c) Make a Pareto chart for the data.


2. The following are the daily high temperatures in Chicago for a single month:

                 56, 58, 62, 64, 66, 67, 67, 67, 69, 69, 70, 70, 71, 71, 72,
                 72, 74, 74, 74, 75, 75, 76, 76, 77, 78, 78, 79, 82, 84, 90

   a) Create a histogram for this data using class width 10.

b) Create a stem/leaf display for this data.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1)Make a frequency table for this data.

A B c J K L M N 0 P Q R S T Class Frequency Histogram Cominteral 16 14 12 2 3 4 1 A 2 AB G H. Cumulative Relative Cumulative

b) Pie chart:

A B G Н. K M N 0 Q Class Cou! interal Frequency Frequency 11 3 1 11 2 3 4 5 6 7 8 9 10 11 12 1 A 2 AB 3 AB 4B 510 6A 710 Tota

c) Paretto chart:

Book1 - Excel Chart Tools Prabhu Pandiarajar Data Review View Developer Analysis Design Design Format O Search 3D Models ta t

E F G H J K L M N o Р + Paretto 18 100% Class intel Frequency А. 11 AB 3 AB B 8 O 15 16 90% 1 I 14 80% 70% 12 1 60% A O 10 1

formula Reference:

A B G Н. J Count Class interal Frequency Relative frequency Cumulative frequency 1 11 3 A AB AB B 0 1 2 1 3 2 4 3 5 4 6 5 7 6

2) Histogram:

AA B c D E J к L M. N 0 Р Q R S Frequency Histogram Class Cou interal Frequency Class Width Midpoint 1 F G Н Cumulative Relat

Formula Ref:

A B D E F. G Н J Count Class interal Frequency Cumulative frequency Cumulative Relative Frequency 1 5666 6676 7686 86_96 4 17

b) Stem/leaf:

А B с F G H - D E Stem-and-Leaf Display 1 Leaf unit: 10 2 3 4 5 6n 30 7 mean 72.1 8 median 72 9 std. dev. 7.265174 10 minimum

Add a comment
Know the answer?
Add Answer to:
Excel Homework #1 1. A researcher is interested in describing the distribution of blood types. She...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Thank you! Listed below are the heights from a sample of male students (in inches 72...

    Thank you! Listed below are the heights from a sample of male students (in inches 72 70 69 75 69 71 75 72 74 73 70 75 74 71 78 65 75 70 a. [3 pts] Create an ordered stem and leaf display for these data. b. [1 pt] How many students are measured? c. [1 pt] What percentage of students are at least 70"? (Round to 1 decimal place.)

  • Provided set of data are concentrations of suspended solids in river water that are collected for...

    Provided set of data are concentrations of suspended solids in river water that are collected for environmental characteristics. Total of 36 samples have concentrations of: 84 49 61 40 83 67 45 66 70 69 80 58 68 60 67 72 73 70 57 63 70 78 52 67 53 67 75 61 70 81 76 79 75 76 58 31 a) Construct a stem‐and‐leaf display of the data. b) Calculate first and third quartiles and median from stem‐and‐leaf display...

  • The following scores represent the final examination grades for an elementary statistics course:

    The following scores represent the final examination grades for an elementary statistics course: 23 60 79 32 57 74 52 70 82 36 80 77 81 95 41 65 92 85 55 76 52 10 64 75 78 25 80 98 81 67 41 71 83 54 64 72 88 62 74 43 60 78 89 76 84 48 84 90 15 79 34 67 17 82 69 74 63 80 85 61 Calculate: Stem and leaf Relative frequency histogram Cumulative frequency Sample Mean Sample Median Mode Variance Standard deviation

  • 02 The following scores represent the final examination grades for an elementary statistics course: 23 60...

    02 The following scores represent the final examination grades for an elementary statistics course: 23 60 79 32 57 74 52 70 82 36 80 77 81 95 41 65 92 85 55 76 52 10 64 75 78 25 80 98 81 67 41 71 83 54 64 72 88 62 74 43 60 78 89 76 84 48 84 90 15 79 34 67 17 82 69 74 63 80 85 61 Calculate: . Stem and leaf ....

  • Show your work AND explain your reasoning using complete English sentences. Explanations must directly follow the...

    Show your work AND explain your reasoning using complete English sentences. Explanations must directly follow the solution for each part of the problem. Listed below are the heights from a sample of male students (in inches). 75 72 72 73 74 65 69 74 70 70 71 75 71 75 69 75 78 70 a. Create an ordered stem and leaf display for these data. b. How many students are measured? c. What percentage of students are at least 70”?...

  • The following data represent glucose blood levels (mg/100 ml) after a 12-hour fast for a random...

    The following data represent glucose blood levels (mg/100 ml) after a 12-hour fast for a random sample of 70 women (Reference American Journal of Clinical Nutrition, Vol. 19, pp. 345-351) 45 668) 71 75 64 59 59 75 82 B0 81 85 77 82 90 87 72 70 69 83 71 87 69 81 76 96 83 67 94 101 94 89 94 73 99 93 85 83 90 78 80 85 83 84 74 81 70 65 89 70...

  • Please answer all questions! thanks :) VI/ Test scores from a math midterm are as follows:...

    Please answer all questions! thanks :) VI/ Test scores from a math midterm are as follows: 79, 90, 85, 89, 70, 59, 75, 64, 83, 78, 75, 77, 78, 77, 67, 85, 74, 52, 87, 72, 69, 76, 61, 77, 93, 86, 79, 90, 74, 67, 51, 75, 77, 82, 78, 60, 86, 72, 91, 95, 82 Complete the frequency distribution table to include all data a. Class Tallies Class Midpoint Relative Cumulative Frequency relative freq boundaries Frequency 51 57...

  • A. Make a stem-and-leaf display for the following data. Comment about the shape of the distribution....

    A. Make a stem-and-leaf display for the following data. Comment about the shape of the distribution. 58    52    68    86    72    66    97    89    84    91    91    92 66    68    87    86    73    61    70    75    72    73    85    84 90    57    77    76    84    93    58    47 B. Construct a frequency distribution using 6 classes with the first lower class limit of 58, draw a Histogram, and what is the shape of distribution? 58, 60, 62, 63, 70, 71, 71, 76,...

  • 12 a and b 12. A distribution has a skewness of-0.14 and a kurtosis of +0.09...

    12 a and b 12. A distribution has a skewness of-0.14 and a kurtosis of +0.09 a. Draw approximately what this distribution should look like. b. What terms would you use to describe this distribution? 13. Build a stem-and-leaf plot for the sibling age data in Table 3.1 14. Create a pie chart showing the percentage of subjects in Table 3.1 who gave each r the language development data in the Waite et al. (2015) study 15. The following data...

  • 2.) Below is a data set for a set of scores on a final exam: 63,...

    2.) Below is a data set for a set of scores on a final exam: 63, 88, 79, 92, 86, 87, 83, 78, 41, 67, 68, 76, 46, 81, 92,77, 84, 76, 70, 66. 77, 75, 98, 81, 82,81, 87, 78, 80, 60, 94, 79, 52, 82, 77, 61, 77, 70, 74, 61 Complete the following questions: (4 points total) (1 point each) a.) Create a frequency distribution by hand b.) Create a histogram by hand c.) Create a stem-and-leaf...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT