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