E BUSS 106 Excel Modified Spring 2019-2ON.pdf (page 31 of 43)- EditedBusiness Applications using Excel- Activity 9-Test your learningInstructions to the student:1. Open a new excel file2. Create a table for the following data in Excel.3. Save the file as "BUSS 106 Excel Activity 12"TotalGradesBoth SexesFemaleMaleKindergarten75,384318338,201Basic educationFirst episode210.269103,636 06.633Basic educationSecond episode128,193 15.338General Education343317Grades (1)Gemeral EdtucationGrades (5 101615.S.169S.006After Basic EducationGrades (11-125S(23241.14243,090Grades (1-6)31.03115.01816,013Grades (79)11.7965,6296167Grades (19 127.8033.4734330Total701,0s1342986358,0951. 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.31282APR 4. Make a column chart for the distribution percentage of females in each category.5. Make a line chart for the distribution percentage of both males and females ineach category.

Name: E BUSS 106 Excel Modified Spring 2019-2ON.pdf (page 31 of 43)- Edited
Uploaded: 2024-03-20T07:07:12.000Z
Channel: Bartleby
Description: E BUSS 106 Excel Modified Spring 2019-2ON.pdf (page 31 of 43)- EditedBusiness Applications using Excel- Activity 9-Test your learningInstructions to the student:1. Open a new excel file2. Create a table for the following data in Excel.3. Save the fi

Math

Statistics

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

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

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

3. The number of goals scored by Wayne Gretzky was recorded for seasons 1978 – 1999. (Please note the data set has been ordered from smallest to the largest for your convenience). 5, 9, 11, 16, 23, 23, 31, 38, 40, 40, 41, 46, 51, 52, 54, 55, 62, 71, 73, 87, 92 A. Construct a stem-and-leaf display for the data and describe the shape of the distribution (symmetric, skewed left, skewed right, bell-shaped, etc., any obvious outliers). B. What is the fraction of the data that is less than or equal to 31? C. Given that Ex, = 920 and Ex = 52 436 find the mean and standard deviation. D. Find the (i) median, (ii) Q1, (iii)Q:, (iv) the interquartile range (IQR), (v) the lower and upper fences. E. Construct a Box-plot for the data. What are your conclusions about the shape of the distribution? Compare with the results in Part A. F. Would the mean or the median be the most suitable measure to use to represent the central location of this distribution? Give reasons for your answer.
Please help on parts f, g, and h (subpart 3)
In a study, researchers wanted to measure the effect of alcohol on the hippocampal region, the portion of the brain responsible for long-term memory storage, in adolescents. The researchers randomly selected 23 adolescents with alcohol use disorders to determine whether the hippocampal volumes in the alcoholic adolescents were less than the normal volume of 9.02 cm. An analysis of the sample data revealed that the hippocampal volume is approximately normal with no outliers and x 8.18 cm and s=0.8 cm. Conduct the appropriate test at the a= 0.01 level of significance. State the null and alternative hypotheses. Ho: H H1: (Type integers or decimals. Do not round.) Identify the t-statistic. to = (Round to two decimal places as needed.) !! Identify the P-value. P-value = (Round to three decimal places as needed.) Make a conclusion regarding the hypothesis. the null hypothesis. There sufficient evidence to claim that the mean hippocampal volume is cm³ Statcrunch Next 8:01 SAMSUNG esc @ %23 $…
The following are the distances (in miles) to the nearest airport for 11 families. 6, 7, 9, 19, 20, 21, 22, 31, 31, 35, 37 Notice that the numbers are ordered from least to greatest. Give the five-number summary and the interquartile range for the data set. Five-number summary Minimum: Lower quartile: Median: Upper quartile: Maximum: Interquartile range: ☐
Please answer in detail
2. Please answer this question ASAP. Please circle all answers, please be organized.
Determine the value of the interquartile range for the following data set: 42, 62, 22, 74, 12, 34, 2 State the interquartile range value rounded to a whole number (no decimals).
Enter Data Set 1, 59, 60, 60, 60, 60, 61, 62, 62, 62, 62, 63, 64, 64, 64, 64, 65, 65, 65, 66, 67, 67, 67, 67, 68, 68, 69, 69, 70, 70, 70, 70, 71, 72, 73 ×
please answer parts a,b,c,d. Thanks