Frequency distribution of Nominal Data

Anonymous
timer Asked: Dec 27th, 2017
account_balance_wallet $15

Question description

Complete the assignment using excel and Email it to me as attachment

Instructions: Follow the instructions exactly as given .

This project is intended to introduce some examples of doing descriptive statistics, and statistical inference.

Application Assignment Due Wednesday January 3 at 8 PM Complete the assignment using excel and Email it to me as attachment Instructions: Follow the instructions exactly as given . This project is intended to introduce some examples of doing descriptive statistics, and statistical inference. Q1. Frequency distribution of Nominal Data Methods of Describing Sets of Data (see a similar example of this question in the word file (Freq dist of Nominal Data ) and the companion excel file (Graph of Table 4 in the example of freq dist nominal data ) on Moodle Week 2 (Examples of materials similar to the questions in Project Assignment 1) In a sample survey of 40 students selected randomly from VIU, the following information were collected from each student about the content of origin (Asia, Africa, North America, South America, Antarctica, Europe and Australia) and gender (male , Female) a. Use the data given in Table 1 to construct three tables showing the distribution by content (Table 2), by Gender (Table 3), and by both content and gender (Table 4). b. Use Excel to construct a column graph of the data in Table 4. Copy the graph from Excel to this word solution file. See the solution below Table 1: Data collected from 40 students ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Content Asia Asia Asia Europe Africa Africa South America Asia Asia South America Africa South America Asia Asia South America Asia Asia Asia Europe Africa Gender Male Male Female Male Female Male Male Female Male Female Male Male Female Male Female Male Male Female Male Female 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Asia Asia Asia Europe Africa Africa South America Asia Asia South America Asia Europe Africa Africa South America Asia Asia Asia Europe Africa Male Male Female Male Female Male Male Female Male Female Female Male Female Male Male Female Male Female Male Female Fill in each of the following tables and insert them in the submitted word file Table 2: Distribution by Content Content Africa Asia Europe South America Total Frequency Percent (%) Table 3 Distribution Gender Country Male Female Total Frequency Percent (%) Table 4 Distribution by content and gender Content\Gender Africa Asia Europe Male Female South America b. To get a column graph of the information in Table 4, follow these instructions. 1. Copy The whole table 4 above (all its 4 rows and 2 columns) , open an excel file and paste Table 4 in that Excel file. 2. After pasting Table 4 in the excel sheet , highlight all Table 4 and click on INSERT in the menu of the Excel file and click twice on the column choice. You will see the graph on your excel sheet 3. click twice (right mouse) on the graph in the excel sheet and you will see a side menu ,select copy from that side menu. 4. go to your solution word file , select the place where you will paste the graph and paste the graph. Save your solution word file Q1 ANSWER in the submitted word file Table 2. Table 3. Table 4. The column graph of Table 4 Q2. Descriptive Statistics of Quantitative Data (measured on Ratio scale) In a sample survey of 50 students selected randomly from VIU, the following information were collected from each student about their scores in two courses (course A the score is X, and Course B the score is Y. Use the data given in the table below and the Data Analysis Option on Excel 2010 or later to obtain the 18 descriptive statistics (Mean, Standard Error, Median, Mode, ….. MAD, IQR ) of both variables X and Y . Table Data on Age and GPA collected from a sample of 40 students selected randomly from VIU. ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 X Y 1 2 2 2 3 3 3 4 4 4 4 5 5 5 5 6 6 6 7 7 7 7 8 8 8 9 9 9 10 10 10 11 11 12 12 13 13 14 14 15 16 16 17 3 4 4 5 5 5 5 6 6 6 6 7 7 7 7 7 8 8 8 8 9 9 9 9 9 10 10 10 10 10 11 11 11 11 12 12 12 13 13 13 14 14 15 44 45 46 47 48 49 50 18 19 21 23 25 29 33 15 16 17 18 19 21 23 Note: Copy the data for the two variables into an excel file and calculate the Descriptive Statistics of both X and Y (using Excel) as explained in class. After you find the required statistics in excel copy them and paste your answer below. Q2 ANSWER in the submitted word file a. The Descriptive Statistics of both X and Y b. Which variable X or Y has a higher grade average , and which variable has a higher variability measured by the standard deviation. Q3. Frequency distribution and Histogram of Quantitative data Use the data for X and Y and their bins for the 50 students in the table presented below, to construct a frequency distribution table of X and the histogram of the X. Also the frequency distribution table of Y and the histogram of the Y as explained in class. Use the data for X and their bins and Y and their bins given below: X Xbins 1 2 2 2 3 3 3 4 4 4 4 5 5 3 6 9 12 15 18 21 24 27 30 33 Y Ybins 3 3 4 5 4 7 5 9 5 11 5 13 5 15 6 17 6 19 6 21 6 23 7 7 5 5 6 6 6 7 7 7 7 8 8 8 9 9 9 10 10 10 11 11 12 12 13 13 14 14 15 16 16 17 18 19 21 23 25 29 33 7 7 7 8 8 8 8 9 9 9 9 9 10 10 10 10 10 11 11 11 11 12 12 12 13 13 13 14 14 15 15 16 17 18 19 21 23 Note: Copy these data and the bins into an excel file and follow the instructions given in the word file (How to Create a Histogram in Excel) on Week 2 of Moodle and the example (create histogram example on excel) in the same place. Make sure you read the instructions carefully . After you find the required frequency table and the histogram in the excel file , copy them and paste your answer below. Q3 ANSWER in the submitted word file Q4. a. THE FREUENCY TABLE of X and THE HISTOGRAM of X b. THE FREUENCY TABLE of Y and THE HISTOGRAM of Y Correlation between two Quantitative data sets Use the data for X and Y of the sample of 50 students given in question 2 above, to calculate the correlation coefficient between X and Y as explained in class. Q4 ANSWER in the submitted word file a. The Correlation between X and Y: b. Present the scatter plot of y vs X below c. Test the significance of the correlation as you did for HW 4 Q5. Simple Linear Regression Equation. Use the data for X and Y a. Do the simple regression analysis using Excel data\data analysis\regression to obtain the regression results and then use them to find the regression equation of Y on X. b. Use the coefficients to present the regression equation to estimate the predicted value of Y if X = 20. Copy the Answer from Excel and paste it below. Q5 ANSWER in the submitted word file a. simple regression analysis results b. The regression equation c. The predicted value of Y when x =20

Tutor Answer

psumanrec
School: New York University

Please find answer.Thank you.

Application Assignment Due Wednesday January 3 at 8 PM
Complete the assignment using excel and Email it to me as attachment
Instructions: Follow the instructions exactly as given .
This project is intended to introduce some examples of doing descriptive statistics, and statistical
inference.

Q1. Frequency distribution of Nominal Data
Methods of Describing Sets of Data (see a similar example of this question in the word file (Freq dist
of Nominal Data ) and the companion excel file (Graph of Table 4 in the example of freq dist nominal
data ) on Moodle Week 2 (Examples of materials similar to the questions in Project Assignment 1)
In a sample survey of 40 students selected randomly from VIU, the following information
were collected from each student about the content of origin (Asia, Africa, North
America, South America, Antarctica, Europe and Australia) and gender (male , Female)
a. Use the data given in Table 1 to construct three tables showing the distribution
by content (Table 2), by Gender (Table 3), and by both content and gender (Table
4).
b. Use Excel to construct a column graph of the data in Table 4. Copy the graph
from Excel to this word solution file. See the solution below
Table 1: Data collected from 40 students
ID
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

Content
Asia
Asia
Asia
Europe
Africa
Africa
South America
Asia
Asia
South America
Africa
South America
Asia
Asia
South America
Asia
Asia
Asia
Europe
Africa

Gender
Male
Male
Female
Male
Female
Male
Male
Female
Male
Female
Male
Male
Female
Male
Female
Male
Male
Female
Male
Female

21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

Asia
Asia
Asia
Europe
Africa
Africa
South America
Asia
Asia
South America
Asia
Europe
Africa
Africa
South America
Asia
Asia
Asia
Europe
Africa

Male
Male
Female
Male
Female
Male
Male
Female
Male
Female
Female
Male
Female
Male
Male
Female
Male
Female
Male
Female

Fill in each of the following tables and insert them in the submitted word file
Table 2: Distribution by Content
Content
Africa
Asia
Europe
South America
Total

Frequency
9
19
5
7
40

Percent (%)
22.5
47.5
12.5
17.5
100

Table 3 Distribution Gender
Country
Male
Female
Total

Frequency
17
23
40

Percent (%)
42.5%
57.5%
100

Table 4 Distribution by content and gender
Content\Gender
Africa
Asia
Europe

Male
5
9
0

Female
4
10
5

South America

3

4

b. To get a column graph of the information in Table 4, follow these instructions.
1. Copy The whole table 4 above (all its 4 rows and 2 columns) , open an excel file and paste Table 4
in that Excel file.
2. After pasting Table 4 in the excel sheet , highlight all Table 4 and click on
INSERT in the menu of the Excel file
and cli...

flag Report DMCA
Review

Anonymous
Awesome! Exactly what I wanted.

Similar Questions
Hot Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors