Claude besides the excel problem you also need to answer to questions which I will text you. I will do 40 dollars for 1 hour
Student name:
Student ID number:
Victoria Wilson
4445680
Before submitting your exam please use this file naming convention:
“Exam3_first initial&last name_studentID#”
Example:
Exam3_vwilson_4473852
DUE: Tuesday, 12/8 at 12:15 pm (or 12:53 pm if you are a DRES client). Submit under the “Assignments” tab
Canvas. Submission window will close at 1:00 pm.
Part 2 of Exam 3 is worth 5 points.
er the “Assignments” tab in
Table 1. Favorite After-School Activites
Activity
Frequency
Play sports
45
Go on social media
77
Earn money
44
Chat online
66
Social clubs
22
Watch TV
37
Table 1 displays the favorite activities of a popula
Exercise Instructions
Create a bar chart using the data set to the left.
1.) Create a bar chart that displays the frequency
2.) Create a bar chart that displays the frequency
3.) Give the chart a title name.
4.) Make sure the horizonal and vertical axes are l
1 pt.
Source: mathgoodies.com
https://www.mathgoodies.com/lessons/graphs/bar_graph
te activities of a population of high school seniors.
e data set to the left.
displays the frequency data on the vertical axis.
displays the frequency data on the horizonal axis.
al and vertical axes are labelled appropriately.
Salary
$
$
$
$
$
$
$
$
$
Table 2. Salary vs. Car price
Car price
42,763.00 $
19,455
195,387.00 $
93,965
35,672.00 $
20,858
217,637.00 $
107,164
74,734.00 $
34,036
130,550.00 $
87,806
42,976.00 $
17,927
151,132.00 $
91,518
54,936.00 $
29,479
Table 2 contains data for a sample of nine research participants
conducted on automobile consumer behavior. The researcher w
customer’s salary is related to what that person is willing to spen
is there a relationship between two variables: salary and car pric
Exercise Instructions
1.) Create a scatter plot using the data set to the left.
2.) Label the horizontal and vertical axes appropriately.
3.) Title the chart, “Salary vs. Car Price”
Source: excel-easy.com
https://www.excel-easy.com/examples/scatter-plot.html
e of nine research participants in a marketing study being
mer behavior. The researcher wants to know if a
at that person is willing to spend on a car. In other words,
wo variables: salary and car price?
data set to the left.
al axes appropriately.
Table 3. Exam Scores
88
72
54
66
89
91
100
100
59
77
76
81
92
86
84
90
88
97
95
99
60
93
Table 3 shows exam scores for a political science class of 22 students. The
total points possible on the exam is 100.
Instructions
Find the mean, median, and modal test scores. Make sure to show the
Excel formula in the formula bar.
1 pt.
ass of 22 students. The
ke sure to show the
Table 3. Exam Scores
88
72
54
66
89
91
100
100
59
77
76
81
92
86
84
90
88
97
95
99
60
93
Instructions
Using the data from Table 3 in the previous exercise, find the following:
Max
Min
Range
Quartile 1
Quartile 3
Interquartile range (IQR)
Make sure the Excel formula is visible in the formula bar.
1 pt.
find the following:
Student
Susan
Lane
GPA
School Mean GPA
3.50
2.85
School Standard Deviation
4.00
3.25
Z-score
0.25
0.60
For each student, determine how many standard deviations her GPA is away from the average, for
the student’s respective school.
Instructions
(1.) Calculate the z-scores for Susan and Lane. Enter those values below.
Susan’s z-score =
Lane’s z-score =
(2.) Identify who has the better GPA when compared to her school.
m the average, for
Purchase answer to see full
attachment
