I am to make an Excel spreadsheet  that provides original data organized in a chart, and displays data in a graph. I handed randomly passed out pamphlet surveys to my class to 20 students and asked them two questions. One: If they drink coffee or another caffeineted stimulant before completing school work. Two- If yes, do they believe it helps them obtain better grades. I provided a picture of an excel sheet with my data. My question is can you show me how believe this data should be best organized in an excel chart and the optimal graph I should use?

Elements Of Modern Algebra
8th Edition
ISBN:9781285463230
Author:Gilbert, Linda, Jimmie
Publisher:Gilbert, Linda, Jimmie
Chapter2: The Integers
Section2.2: Mathematical Induction
Problem 7E
icon
Related questions
Question
100%

I am to make an Excel spreadsheet  that provides original data organized in a chart, and displays data in a graph.

I handed randomly passed out pamphlet surveys to my class to 20 students and asked them two questions. One: If they drink coffee or another caffeineted stimulant before completing school work. Two- If yes, do they believe it helps them obtain better grades.

I provided a picture of an excel sheet with my data. My question is can you show me how believe this data should be best organized in an excel chart and the optimal graph I should use? 

1 Do you drink coffee or another caffeineted stimulate before schoolwork?
2 Yes
3 No
4 No
5 No
6 Yes
7 Yes
8 No
9 Yes
10 Yes
11 No
12 Yes
13 Yes
14 No
15 Yes
16 No
17 No
18 No
19 Yes
20 Yes
If yes do you believe it helps you with your grades
Yes
Yes
No
No
No
Yes
Yes
No
No
No
Transcribed Image Text:1 Do you drink coffee or another caffeineted stimulate before schoolwork? 2 Yes 3 No 4 No 5 No 6 Yes 7 Yes 8 No 9 Yes 10 Yes 11 No 12 Yes 13 Yes 14 No 15 Yes 16 No 17 No 18 No 19 Yes 20 Yes If yes do you believe it helps you with your grades Yes Yes No No No Yes Yes No No No
Expert Solution
steps

Step by step

Solved in 2 steps with 5 images

Blurred answer
Recommended textbooks for you
Elements Of Modern Algebra
Elements Of Modern Algebra
Algebra
ISBN:
9781285463230
Author:
Gilbert, Linda, Jimmie
Publisher:
Cengage Learning,
Algebra: Structure And Method, Book 1
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
Algebra and Trigonometry (MindTap Course List)
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:
9781305071742
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781337282291
Author:
Ron Larson
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage