Instructions to the student: 1. Open a new excel file 2. Create a table for the following data in Excel. 3. Save the file as "BUSS 106 Excel Activity 12" Total Grades Femal Male Kindergarte 25,384 37183 38.201 Basic education First episode 103,636 106,633 Basic educarion Second episode 263,331 128.193 135-338 General Education Grades (1-4) 560 243 317 General Education Grades (5) 1615 S.169 5.006 After Basic E ducation Grades (11-12) S4.232 41.142 43,090 Grades (1-6) 31.031 15.01S 16.013 Grades ("-9) 11.796 5,629 6.167 Grades (10 12 803 3.473 4.330 Total 701,0s1 342986 358,095 1. Calculate the percentage of males and females in each category. 2. Calculate the distribution percentage of students in each category gender wise. 3. Make a bar chart for the distribution percentage of males in each category. 31

Q: Below are the commodity data. Determine (a) Laspeyer's price index and Laspeyer's quantity index.…

A:

Q: The amount of money earned in a day by Ms. Anne’s craft shop was recorded and displayed in the…

A: Here, the maximum value is 61 and the minimum value is 25. Thus, the range of the distribution is 61…

Q: 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 data Based on the boxplot above, identify the 5 number…

A: Boxplot

Q: The data presented in the Table below show the Price and Quantity of selected export commodities for…

A: Given information: As per guidelines we will solve the first question only, please repost other…

Q: Year 1915 1920 1925 1930 1935 1940 1945 1950 1955 Rate 3.1 2.2 5.3 7.5 8.5 7.4 10.3 22.1 17.6…

A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: you must input the following data: Variable name: Low-sugar diet; label: low_feed_consumed: 8.5,…

A: Data given  Variable name: Low-sugar diet; label: low_feed_consumed: 8.5, 8.0, 13.2, 6.8, 6.45, 6.0,…

Q: Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in…

A: From the following data, computing MSE as follows,

Q: Table 1: Significant difference in the Management Capability of Administrators When Grouped Gender…

A: From the given information, Null Hypothesis: H0: There is no significance difference in the…

Q: 6. Draw the Histogram for the following data class 0-10 10-20 20-30 frequency 10 18 30 30-40 42…

A: The objective is to draw a histogram for the following data: class interval 0-10 10-20 20-30…

Q: The question is from the below book: Book-Analysis of biological data 2nd Edition Michael C.…

A: a) Bar chart:   Bar chart is the graphical way of representing the data values using bars…

Q: 4 60 70 80 90 100 Median: Click to add title Upper Quartile: Click to add title Lower Quartile:…

A:

Q: We are given the following data set and we are to make a stem-and-leaf display of this data. 28 9 31…

A: A data can be raw or grouped, with some pro and cons associated with both of them. The raw data has…

Q: This question refer to the following data: Sentence Year. 13 10 8 6 4 7 14 9. 7 What is the mode?…

A: Given data, 13,10,8,6,4,7,14,9,7 Mode=?

Q: CHAPTER 6-General Health and Population Indicators The next three questions relate to the following…

A: 1) Infant Mortality Rate   2) Maternal Mortality Rate 3) Crude Mortality Rate   due to Cancer 4)…

Q: The staff of controller of McCourt Company added the variable "pounds moved" to the ten-month data…

A: Note: Hey, since there are multiple subparts posted, we will answer first two subparts. If you want…

Q: Given the following list of data, what is the five-number summary? 5, 5, 8, 8, 10, 12, 12, 13, 13,…

A: The five number summary is, minimum value, lower quartile, median, upper quartile and maximum value.

Q: The table below contains real data for the first two decades of AIDS reporting. Year # AIDS cases…

A: As per our guidelines, we are allowed to answer first three sub-parts only. Thanks Given Data :…

Q: The data to the right contain the per-capita energy consumption, in kilowatt-hours, for each of the…

A: Given data,15,628      14,954    14,051    12,803       12,05111,978      11,264    11,175    10,689…

Q: Classify the data as either qualitative or quantitative. The following table gives the top five…

A: We need to identify data as either qualitative or quantitative

Q: b) The amount of money earned in a day by Ms. Anne's craft shop was recorded and displayed in the…

A: Here we can observe that total number of observations is 34. Thus the median is the average of the…

Q: Calculate SStotal, SSbetween, and SSwithin for the following set of data: Treatment 1 Treatment 2…

A: Given, Treatment 1 Treatment 2 Treatment 3   n=5 n=5 n=5 N=15 T=10 T=15 T=35 G=60 SS=21…

Q: 1. 1 Of the following classified data is:

A: given: class interval midpoint(x) frequency(f) x*f 50-60 55 8 440 60-70 65 10 650 70-80 75…

Q: A Give the original data set from the stemplot given below. 4 0 0 1 5 5 2 27 6. 70 7 7 99

A:

Q: An auto insurance company reported the following information regarding the age of a driver and the…

A: Given Information: The data represents the age of a driver and the number of accidents reported last…

Q: The following data are based on information from the book Life in America's Small Cities (by G.S.…

A: Given x y 24.2 13 19 4.4 18.2 9.3 14.9 1.3 19 0.8 17.5 3.6   Alpha=0.05

Q: A certain livelihood program was given to 15 farmers to enhance their income. The data were recorded…

A: Let, d = After the implementation - Before the implementation The null and alternative hypothesis is…

Q: State the Five Number Summary for the following dataset. 0.03   0.04   0.05   0.07   0.08   0.09…

A: given data in ascending order; number of…

Q: The table below contains real data for the first two decades of AIDS reporting. Year # AIDS cases…

A: Graph year versus AIDS deaths: Steps to construct scatter plot in Excel: Enter Year and AIDS deaths…

Q: Is fishing better from a boat or from the shore? Pyramid Lake is located on the Paiute Indian…

A: (a) For testing the two-tailed hypothesis of H0:μd=0H1:μd≠0 1st option is correct. and the level of…

Q: I. Draw the appropriate graph for each of the data sets given below and give a short interpretation…

A: Solution: For table 1 of mortality rates in Philippines, from (1976 -1990), we can draw a Column…

Q: A cross-tabulation of sales transactions data is shown to the right. Use the data to complete parts…

A: Given:

Q: Use the data table below to answer the questions regarding the relationship between sit-ups (X) and…

A:

Q: Table 3.3 gives the 2008 profits (rounded to billions of dollars) of 12 companies selected from all…

A:

Q: Find out the appropriate measures of location for the given data set: Classes -250 250-500 500-750…

A: The given data is as follows: Class Frequency (f) 0 - 250 12 250 - 500 20 500 - 750 23…

Q: In an upcoming decision to relocate, a new graduate’s decision on location choice comes  down to…

A: Given, In an upcoming decision to relocate, a new graduate’s decision on location choice comes down…

Q: Here is a data set summarized as a stem-and-leaf plot: Stem Leaf 6 1 2 2 3 4 9 7 2 2 2 2 4 9 9 8 4…

A: The stem and Leaf plot is given.

Q: Boats (tens of thousands) Manatees 69 54 67 39 64 35 71 48 71 44 72 60 76 54 82 66 82 80 86 78 91 79…

A: Given, Boats(X) Manatees(Y) 69 54 67 39 64 35 71 48 71 44 72 60 76 54 82 66 82…

Q: For the following data, what is SStotal? ​Treatments Subject I II…

A:

Q: #10. The following data represent annual salaries, in thousands of dollars, for employees of a small…

A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: What is the ratio of deaths from gastroenteritis to heart disease in the total population, and in…

A: Given Data :

Q: Consider the following data regarding the average spending on health care person for various…

A: Hai

Q: 7) For the following data Classes 74.45 94.45 114.45 134.45 154.45 174.45 194.45 Frequency 9 10 17…

A:

Q: 1. There is a group of data as follows: 83 75 66 26 37 87 24 77 90 84 34 22 31 68 92 46 81 41…

A: Given the data as 83, 75, 66, 26, 37, 87, 24, 77, 90, 84, 34, 22, 31, 68, 92, 46, 81, 41

Q: alculate SStotal, SSbetween, and SSwithin for the following set of data:        Treatment 1…

A: given that SS = 27       SS = 16       SS = 23   ∑X2 = 206

Q: The following data represent the hel that operate in real-state sector. 56 97 78 61 79 93 84 76 58…

A: as you can see in above data there 25 company whose net profit is given and we can calculate average…

Q: The data to the right contain the​ per-capita energy​ consumption, in​ kilowatt-hours, for each of…

A: The mean is calculated as follows: The population standard deviation is calculated as follows:

Q: Below are the commodity data. Determine (a) Laspeyer's price index and Laspeyer's quantity index.…

A:

Q: Example 3 Draw bar diagram for the following data. Years 1996 1997 1998 1999 2000 2001 Scale (*000)…

A: We have the following data  to draw a bar diagram.

Q: (3.36 Draw (i) a Histogram and (ii) an Ogive from the following data: Daily wages (Rs.) 4-6 6-8 8-10…

A: Given frequency distribution: Daily wages No. of employees 4-6 13 6-8 111 8-10 182 10-12…

Q: What is the two year moving average forecast for 2016?   U.S. Manufactured General Aviation…

A: 2-period moving average: