Questions What is the total number of students surveyed? Answer 126 How many students have the following types of phone? % 12 9.5% Android iPhone 114 90.5% Create a pie chart showing the breakdown of Android and Apple Phones How many students have the following types of laptop? Windows Apple % 56 44.44% 59 46.83% 5 3.97% Dont own a laptop Create a pie chart showing the breakdown of laptop types What percentage of students with a tablet have an Android tablet? All answers must use an excel formula Extended Question How many students have the following type of device? Phone Laptop Desktop Computer Tablet What is the average number of devices a student has? All answers must use an excel formula Questions How many students are planning to study the following diplomas? Commerce IT Engineering Business Design Communication Science Create a bar graph showing how many students are enrolled in each diploma All answers must use an excel formula Extended Question How many students are in Engineering, IT or Design and do not have a laptop Answer 126 121 21 59 2.6 Answer 6.78% 14 22 6 22 9 20 5 25 20 15 10 Answer 5 0 Breakdown of student phone OS's Android iPhone 90% Android iPhone 10% Breakdown of student type of laptop Dont own a laptop 4% Apple 49% Windows Apple ■Dont own a laptop Windows 47% Number of students planning to study each diploma I\.\.\. Commerce Engineering Business Design Communication Science 45 45 40 35 30 25 45 20 15 10 10 5 Pop, 40 Students likeness of each genre of music Hip Hop, 33 Country, 17 Jazz, 15 Rock, 14 Blues, 11 Other, 21 0 Pop Hip Hop Rock Jazz Country Blues Other 40 35 30 25 15 10 25250 Students llikeness of each game Indifferent Its good Valorant COD Counterstrike DOTA Never Played League of Legends It sucks

Ciccarelli: Psychology_5 (5th Edition)
5th Edition
ISBN:9780134477961
Author:Saundra K. Ciccarelli, J. Noland White
Publisher:Saundra K. Ciccarelli, J. Noland White
Chapter1: The Science Of Psychology
Section: Chapter Questions
Problem 1TY
icon
Related questions
Question
From the image below explain each of the graph and using data from the worksheet to support your answers, what do you recommend for the following: 1. If university made a phone app, should an Android or iOS (iPhone) app be the priority? 2. Is it worthwile to develop resources for MacOS (Apple) users? 3. Which Diploma will need more teachers after this years Foundation students finish the Foundation program? 4.If universities had a radio station in the building, what main genres of music should they play? 5. Should universities try hold a game tournament and if yes: -Which games would you recommend that would have the most potential competitors? NO AI PLEASE
Questions
What is the total number of students surveyed?
Answer
126
How many students have the following types of phone?
%
12
9.5%
Android
iPhone
114
90.5%
Create a pie chart showing the breakdown of Android and Apple Phones
How many students have the following types of laptop?
Windows
Apple
%
56
44.44%
59
46.83%
5
3.97%
Dont own a laptop
Create a pie chart showing the breakdown of laptop types
What percentage of students with a tablet have an Android tablet?
All answers must use an excel formula
Extended Question
How many students have the following type of device?
Phone
Laptop
Desktop Computer
Tablet
What is the average number of devices a student has?
All answers must use an excel formula
Questions
How many students are planning to study the following diplomas?
Commerce
IT
Engineering
Business
Design
Communication
Science
Create a bar graph showing how many students are enrolled in each diploma
All answers must use an excel formula
Extended Question
How many students are in Engineering, IT or Design and do not have a laptop
Answer
126
121
21
59
2.6
Answer
6.78%
14
22
6
22
9
20
5
25
20
15
10
Answer
5
0
Breakdown of student phone OS's
Android
iPhone
90%
Android iPhone
10%
Breakdown of student type of laptop
Dont own a laptop
4%
Apple
49%
Windows Apple ■Dont own a laptop
Windows
47%
Number of students planning to study each
diploma
I\.\.\.
Commerce
Engineering
Business
Design
Communication
Science
Transcribed Image Text:Questions What is the total number of students surveyed? Answer 126 How many students have the following types of phone? % 12 9.5% Android iPhone 114 90.5% Create a pie chart showing the breakdown of Android and Apple Phones How many students have the following types of laptop? Windows Apple % 56 44.44% 59 46.83% 5 3.97% Dont own a laptop Create a pie chart showing the breakdown of laptop types What percentage of students with a tablet have an Android tablet? All answers must use an excel formula Extended Question How many students have the following type of device? Phone Laptop Desktop Computer Tablet What is the average number of devices a student has? All answers must use an excel formula Questions How many students are planning to study the following diplomas? Commerce IT Engineering Business Design Communication Science Create a bar graph showing how many students are enrolled in each diploma All answers must use an excel formula Extended Question How many students are in Engineering, IT or Design and do not have a laptop Answer 126 121 21 59 2.6 Answer 6.78% 14 22 6 22 9 20 5 25 20 15 10 Answer 5 0 Breakdown of student phone OS's Android iPhone 90% Android iPhone 10% Breakdown of student type of laptop Dont own a laptop 4% Apple 49% Windows Apple ■Dont own a laptop Windows 47% Number of students planning to study each diploma I\.\.\. Commerce Engineering Business Design Communication Science
45
45
40
35
30
25
45
20
15
10
10
5
Pop, 40
Students likeness of each genre of music
Hip Hop, 33
Country, 17
Jazz, 15
Rock, 14
Blues, 11
Other, 21
0
Pop
Hip Hop
Rock
Jazz
Country
Blues
Other
40
35
30
25
15
10
25250
Students llikeness of each game
Indifferent
Its good
Valorant
COD
Counterstrike
DOTA
Never Played
League of Legends
It sucks
Transcribed Image Text:45 45 40 35 30 25 45 20 15 10 10 5 Pop, 40 Students likeness of each genre of music Hip Hop, 33 Country, 17 Jazz, 15 Rock, 14 Blues, 11 Other, 21 0 Pop Hip Hop Rock Jazz Country Blues Other 40 35 30 25 15 10 25250 Students llikeness of each game Indifferent Its good Valorant COD Counterstrike DOTA Never Played League of Legends It sucks
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Recommended textbooks for you
Ciccarelli: Psychology_5 (5th Edition)
Ciccarelli: Psychology_5 (5th Edition)
Psychology
ISBN:
9780134477961
Author:
Saundra K. Ciccarelli, J. Noland White
Publisher:
PEARSON
Cognitive Psychology
Cognitive Psychology
Psychology
ISBN:
9781337408271
Author:
Goldstein, E. Bruce.
Publisher:
Cengage Learning,
Introduction to Psychology: Gateways to Mind and …
Introduction to Psychology: Gateways to Mind and …
Psychology
ISBN:
9781337565691
Author:
Dennis Coon, John O. Mitterer, Tanya S. Martini
Publisher:
Cengage Learning
Psychology in Your Life (Second Edition)
Psychology in Your Life (Second Edition)
Psychology
ISBN:
9780393265156
Author:
Sarah Grison, Michael Gazzaniga
Publisher:
W. W. Norton & Company
Cognitive Psychology: Connecting Mind, Research a…
Cognitive Psychology: Connecting Mind, Research a…
Psychology
ISBN:
9781285763880
Author:
E. Bruce Goldstein
Publisher:
Cengage Learning
Theories of Personality (MindTap Course List)
Theories of Personality (MindTap Course List)
Psychology
ISBN:
9781305652958
Author:
Duane P. Schultz, Sydney Ellen Schultz
Publisher:
Cengage Learning