statistics help needed continued

profilesandyp86
final_answers_assignment_2_0-2.xlsx

DATA

Enjoying_ACA Wished_course Proffesionally_advancing Accomplished_Staff How_long_in_school Period_before_work
0 1 0 1 4 5
0 0 0 0 6 4
1 0 0 0 6 2 BIN Bin Frequency
0 1 1 0 6 5 1 1 5
0 0 0 1 4 3 2 2 9
0 1 0 1 3 5 3 3 8
0 1 1 0 3 5 4 4 9
0 0 0 0 6 5 5 5 9
0 1 0 1 3 3 More 0
0 0 0 1 5 3
0 0 1 1 5 2
0 0 0 1 3 2
0 1 1 0 5 1
1 0 1 0 2 2
1 1 1 0 5 4 Bin Frequency
1 1 1 0 2 5 2 7
1 1 0 0 4 4 3 8
0 0 1 1 3 5 4 7
0 1 0 0 2 2 5 8
1 0 0 1 3 2 6 10
1 1 0 0 6 5
1 0 0 0 5 1
0 1 1 0 2 3
0 1 0 0 5 2
1 1 0 0 2 5
0 1 1 1 4 2
1 1 0 1 4 3
0 0 1 0 2 4
1 1 0 1 3 1
1 0 1 1 6 4
0 0 0 0 3 3
1 0 0 1 2 1
0 1 1 1 6 2
0 0 0 1 6 4
1 1 0 0 6 3
0 1 1 0 6 4
0 0 1 1 4 4
1 0 1 1 5 4
0 1 0 0 4 1
0 1 1 0 5 3
KEY COLUMN A-E
YES 0 Yes
NO 1 NO

Histogram QSTN 5

Frequency 2 3 4 5 6 7 8 7 8 10

Number of years in School

Frequency

Histogram QSTN 6

Frequency 1 2 3 4 5 More 5 9 8 9 9 0

Number of years before getting work

Frequency

QUESTION 1

sample size the sample size that took part in the survey is 40 respondents. This was made up of a mixture of males and females
Proportions There were two responses while examining those who were enjoying their stay at Acapella university
YES 25
NO 15
from the above we can see that 0.625 of the students are actually enjoying their stay at Capella University. Only 0.375 are not enjoying their stay as suggested by the data
from the above we can come up with the following pie chart;
YES NO 25 15

QUESTION 2

sample size the sample size that took part in the survey is 40 respondents. This was made up of a mixture of males and females. This is the case for all cell between A and D
Proportions There were two responses while examining those who were called for the courses they had wished for
YES 18
NO 22
from the above we can see that 0.45 of the students were actually called for the course they had wished for. The remaining 0.55 of the students were called for a course that they were not on 1st choice
PIE CHART from the above we can come up with the following pie chart;

1st Course that you wished for

YES NO 18 22

QUESTION 3

sample size the sample size that took part in the survey is 40 respondents. This was made up of a mixture of males and females
Proportions There were two responses while examining those who felt they were proffesionally advancing in Acapella University
YES 23
NO 17
from the above we can see that 0.575 of the students are actually feeling that they are proffesionally advancing at Capella University towards their proffesion while 0.425 feel there are hardly making progress towards their proffesion.
Bar graph from the above we can come up with the following bar graph;

ARE YOU PROFFESIONALY ADVANCING

YES NO 23 17

QUESTION 4

sample size the sample size that took part in the survey is 40 respondents. This was made up of a mixture of males and females
Proportions There were two responses while examining those who felt the staff were Accomplished enough to see them through
YES 22
NO 18
from the above we can see that 0.55 of the students are actually feeling that the staff at Acapella University are accomplished enough to help see them through.
Bar graph from the above we can come up with the following pie chart;

Accomplished Staff

YES NO 22 18

QUESTION 5

Some of the observation I am interested in are;
Sample mean 4.15
this implies that on average the responds had stayed at Acapella University for the 2.7 years which is approximately 2 years and 8 months
Sample median 4
This implied that the median age for the respondents having stayed at Acapella University is 2 years
Sample Mode 6
most of the individual had spent 6 years at Acapella University
Sample Range 4
the range which is the difference between the maximum number of years and the minimum number of years is given by 4 years
Sample Standard Dev 1.4597154623
The deviation of the years spent in school from the mean age is given as 1.46 years
Maximum years 6
the maximum number of years in school at Acapella is given as 6
Minimum Years 2
The minimum years an individual takes in Acapella university
HISTOGRAM Bin Frequency
2 7
3 8
4 7
5 8
6 10
More 0

Histogram

Frequency 2 3 4 5 6 7 8 7 8 10

Number of years in School

Frequency

QUESTION 6

Some of the observation I am interested in are;
Sample mean 3.2
this implies that on average the respondents expected to spend on average 3.2 years before they secured a job
Sample median 3
This implied that the median age for the respondents to have secured a job was 3 years
Sample Mode 5
most of the individual had spent 5 years before securing a job as this was the most frequent year for most of the respondents
Sample Range 4
the range which is the difference between the maximum number of years and the minimum number of years is given by 4 years before securing a job
Sample Standard Dev 1.3625014702
The deviation of the years spent before getting a job from the mean years of a getting a job is given as 1.46 years
Maximum years 5
the maximum number of years an individual expects to staying getting a job at Acapella is given as 5
Minimum Years 1
the minimum number of years an individual expects to staying getting a job at Acapella is given as 5
HISTOGRAM Bin Frequency
1 5
2 9
3 8
4 9
5 9
More 0

Histogram QSTN 6

Frequency 1 2 3 4 5 More 5 9 8 9 9 0

Number of years before getting work

Frequency

Sheet8

Enjoying_ACA How_long_in_school Period_before_work
1 6 2
1 2 2
1 5 4
1 2 5
1 4 4
1 3 2
1 6 5
1 5 1
1 2 5
1 4 3
1 3 1
1 6 4
1 2 1
1 6 3
1 5 4
how long in school period before work
MEAN 4.0666666667 3.0666666667
mode 6 4

EXPLORATION OF DATA

I decide to run a descriptive of the respondents who did not enjoy school agains the average amount of time they expected to be in school.The average number of years they expected to be school was 4 years while most of the (mode) had been in school for 6 years
Using the same indoviduals who didn’t enjoy their stay at Acapella University, they expected to stay atleast 3 years before getting work while the modal time before getting work was 4 years in this group.