# Frequency distribution of Nominal Data

Anonymous
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.

psumanrec
School: New York University

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.

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