statistics help needed continued
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 10Number of years in School
Frequency
Histogram QSTN 6
Frequency 1 2 3 4 5 More 5 9 8 9 9 0Number 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; |
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 22QUESTION 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 17QUESTION 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 18QUESTION 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 10Number 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 0Number 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. | |