Question
eCampusOntario.ca is the primary face of the Ontario Online Learning Consortium (OOLC), a not-for-profit corporation whose membership is composed of all publicly-funded colleges and universities
eCampusOntario.ca is the primary face of the Ontario Online Learning Consortium (OOLC), a not-for-profit corporation whose membership is composed of all publicly-funded colleges and universities in Ontario. Funding for OOLC and the eCampusOntario initiative comes from the Government of Ontario.
eCampusOntario.ca was created in 2015 primarily as a portal for learners to find online courses - through browsing, searching by keyword, or filtering by institution and delivery format. Course details include links to information about scheduling, tuition and fees, instructors, and information about how to get registered and to seek credit transfer. Previously identified course equivalencies are also listed where available. In addition, students can search based on a specific course they need credit for to find available online options at other institutions.
Aiming to improve its services, eCampusOntario has collected data from 33 nursing students, 33 business students and 33 education students on their satisfaction with the eCampusOntario portal prior to registration for any courses (stage 1) and after registration (stage 2). The following information is available for each stream (refer to data sheet):
age of the respondents gender (1=male and 2=female) Student satisfaction of stage 1 (ranges from 0 (extremely dissatisfied) to 5 (extremely satisfied)) Student satisfaction of stage 2 (ranges from 0 (extremely dissatisfied) to 5 (extremely satisfied))
1- Conduct a descriptive analysis of the sample of business students which includes the following:
-Appropriate measures of central location and variance for each variable.
-Represent each variable in a stand-alone graph using one of the types of graphs
discussed in the course. Be sure to use a type of graph that is appropriate for the
variable.
-Represent both satisfaction levels in a single graph using one of the types of
graphs discussed in the course.
I just need help with the third part of question 1, i cant seem to figure out how to put the data into a graph on xl stat, if you could help me and give me instructions on how to do this that would be great!
Business | |||
Age | Gender | Business-Student Satisfaction of Stage 1 | Business- Student Satisfaction of Stage 2 |
18 | 1 | 3.02 | 2.83 |
19 | 1 | 3.70 | 3.82 |
21 | 1 | 4.39 | 4.39 |
22 | 1 | 4.47 | 4.00 |
23 | 1 | 3.13 | 2.50 |
23 | 1 | 3.71 | 3.34 |
23 | 1 | 4.50 | 4.22 |
25 | 1 | 3.74 | 3.71 |
26 | 1 | 3.58 | 3.71 |
26 | 1 | 3.79 | 2.90 |
30 | 1 | 2.76 | 2.48 |
30 | 1 | 3.50 | 3.11 |
33 | 1 | 4.35 | 4.29 |
38 | 1 | 2.83 | 2.00 |
52 | 1 | 1.30 | 0.50 |
18 | 2 | 3.60 | 3.11 |
19 | 2 | 2.88 | 1.87 |
19 | 2 | 4.41 | 4.00 |
20 | 2 | 2.95 | 2.72 |
22 | 2 | 3.00 | 2.00 |
22 | 2 | 3.11 | 2.91 |
22 | 2 | 3.75 | 2.90 |
23 | 2 | 2.81 | 2.80 |
24 | 2 | 1.00 | 0.50 |
24 | 2 | 3.23 | 2.77 |
26 | 2 | 3.52 | 3.52 |
27 | 2 | 1.38 | 1.00 |
27 | 2 | 4.48 | 4.00 |
31 | 2 | 3.10 | 2.98 |
32 | 2 | 3.46 | 3.22 |
37 | 2 | 3.78 | 3.12 |
43 | 2 | 2.86 | 1.50 |
51 | 2 | 3.57 | 3.22 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started