Question

In: Statistics and Probability

How do I create a histogram for the following set of data? Legend: Result (1-100) Age...

How do I create a histogram for the following set of data?
Legend:
Result (1-100)
Age and gender are self explanatory
Relationship (are you in a romantic relationship?)
Medu (Mothers highest lvl of education. 1= year 10; 2= year 12; 3=bachelor; 4= post grad
Lectures (how many lectures missed)
Tutorials (How many tutorials missed)

RESULT Gender Age Medu Relationship Lectures Tutorials
55 F 20 4 NO 4 3
55 F 19 1 NO 2 3
65 M 18 4 NO 6 4
65 M 18 2 NO 0 0
65 F 18 3 NO 0 1

Solutions

Expert Solution

Note : The method to create the histogram has been shown in the answer. You need to put the actual data and follow the steps.

Sample data for 25 observation has been created as shown below.

Find the histogram for results.
The result range from 1-100, hence we shall have 5 intervals with a width of 20.

We shall find the number of observation that find in each interval and put in the table as shown below.

Next we plot the graph using the insert graph option in excel as shown.

This method can be used for age, Lectures and Tutorials.

Finding the histogram for gender.

Count the number of males and Female and put them in table.

Next we plot the histogram using this data as shown.


Related Solutions

create a histogram of with the data. One relatively easy way to do this is to...
create a histogram of with the data. One relatively easy way to do this is to divide the counts into 10 groups, say, each of length: (max length - min length)/10. Then compute the frequency of the data in each bin, and plot. data: 143.344, 178.223, 165.373, 154.768, 155.56, 163.88, 178.99, 145.764, 174.974, 136.88, 173.84, 174.88, 197.091, 183.222, 138.233 please show work
How do I do this in Minitab 1. The data set ‘Golf Disks’ is the weight...
How do I do this in Minitab 1. The data set ‘Golf Disks’ is the weight in grams of a random sample of 12 Golf Disks (for playing disk golf). Construct a 95% CI for the mean weight of all golf discs produced by this particular manufacturer. State the meaning of μ first and then determine if the data set is ≈ normal by displaying a box plot and a normal probability plot, and then interpret the plots. Show the...
Create a histogram of this data with 15 bins. Create a box plot of this data.
7, 9, 8, 11, 14, 7, 11, 17, 18, 12, 10, 9, 16, 17, 15, 13, 7, 12, 7, 8, 14, 16, 20, 12, 11, 14, 22, 8, 10, 14, 15, 20, 17, 14, 12, 22, 12, 15, 17, 16, 9, 11, 16, 18, 11, 12, 11, 9, 11, 9, 13, 7, 12, 9, 19, 9, 8, 15, 12, 16, 16, 20, 21, 9, 11, 17, 17, 8, 11, 7, 10, 17, 13, 15, 14, 11, 19,10, 11, 11, 9,...
How do I do  independent t test on the data set below and how do I know...
How do I do  independent t test on the data set below and how do I know if its pooled t test or unrolled t test? Health question for reference: to what extend does the age of MI patients vary by gender Standard deviation: male = 13.944 female= 13.939 mean: male 65.353 female=73.628 Male female 65   88 77   81 78   82 76   66 40   81 83   73 58   64 43   53 39   69 66   67 61   89 49   85 85   81...
Create a histogram and relative frequency histogram for the data in table #2.2.10. Describe the shape...
Create a histogram and relative frequency histogram for the data in table #2.2.10. Describe the shape and any findings you can from the graph. Table #2.2.10: Data of Median Income for Females $31,862 $40,550 $36,048 $30,752 $41,817 $40,236 $47,476 $40,500 $60,332 $33,823 $35,438 $37,242 $31,238 $39,150 $34,023 $33,745 $33,269 $32,684 $31,844 $34,599 $48,748 $46,185 $36,931 $40,416 $29,548 $33,865 $31,067 $33,424 $35,484 $41,021 $47,155 $32,316 $42,113 $33,459 $32,462 $35,746 $31,274 $36,027 $37,089 $22,117 $41,412 $31,330 $31,329 $33,184 $35,301 $32,843 $38,177 $40,969...
1. As a result of running a simple regression on a data set, the following estimated...
1. As a result of running a simple regression on a data set, the following estimated regression equation was obtained:       = 9.7 + 13.4x Furthermore, it is known that SST = 622, and SSE = 150. 2. You are given the following information about y and x: y x Dependent Variable Independent Variable 11 6 15 5 10 2 14 2 Linear regression using least squares method yielded the following equation:   = 12.06 + 0.12x What is the predicted value...
Q1 (100%): Using data below, do the following: 1) Create the efficient frontier; 2) Calculate the...
Q1 (100%): Using data below, do the following: 1) Create the efficient frontier; 2) Calculate the optimal portfolio; 3) Draw the Capital Market Line. Note the line must be based on data, not your fine art skills. Security A Security B Portfolio Mean 0.09 0.15 Standard Deviation 0.20 0.33 Variance 0.04 0.11 Covariance 0.0095 Risk-free rate 5.20% please attach the exal work so i can downlond it
how do I make a histogram. I am using the example from the book Essentials of...
how do I make a histogram. I am using the example from the book Essentials of Statistics Chapter 2.2, Problem 9BSC.
How do I calculate the concentration of ascorbic acid in (mg/100 mL) from the following data?...
How do I calculate the concentration of ascorbic acid in (mg/100 mL) from the following data? C6H8O6 + I2 → C6H6O6 + 2I- + 2H+ KIO3 + 5KI + 6H+ → 3I2 + 6K+ + 3H2O Molarity of KIO3 = 0.001987 mol/L Volume of unknown = 10.0 mL Volume of KIO3 used = 33.90 mL The calculation scheme given was: Volume of KIO3 = mols of KIO3 (use molarity) = mols of I2 (1:3 ratio) = mols C6H8O6/ 10.0 mL...
There are several ways to describe data like the Histogram; what is the Histogram? Discuss how...
There are several ways to describe data like the Histogram; what is the Histogram? Discuss how to use Excel to produce Histogram and what can you use it for? What is descriptive statistics? How can you use descriptive statistics through Analysis Tool Pack add-in in Excel? Discuss how to use Descriptive Statistics to produce measures of center or dispersion? Can these be sued to support decision making? How?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT