Question

Chpt 4 Using Excel, create a scatter diagram of the data shown below including the linear...

Chpt 4
Using Excel, create a scatter diagram of the data shown below
including the linear equation of the relationship & the
r2coefficient. Make it look professional & colorful.
Explain what the chart shows.
Hours of Study/ week gpa
2 1.6
1 1.1
5 1.8
6 2
7 2.1
21 3.9
14 3
16 3.1

Homework Answers

Answer #1

Explanation about the data:

the data is given about the hours of study per week as one variable and resulting GPA as depending variable

from the chart it can be shown that there is highly positive correlation between the two variable means hours of study has high effect on the resulting gpa.

so there is a high degree of relationship between hours of study and resulting gpa.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Analyzing Advertising Expenditure As a data scientist of a company, you want to analyze the following...
Analyzing Advertising Expenditure As a data scientist of a company, you want to analyze the following data collected by your company which relates the advertising expenditure A in thousands of dollars to total sales S in thousands of dollars. The following table shows this relationship: Advertising Expenditure (A) Total Sales (S) 19 325 21 329 21.5 328 23 333 23 331 26 340 27.3 341 Determine if the above relation (A, S) defines a function or not. Using Excel, draw...
Using only the California sales data through Excel Date Chicago Seasonal Relatives for Chicago Sales California...
Using only the California sales data through Excel Date Chicago Seasonal Relatives for Chicago Sales California New York 1/4/18 152 0.3 640 456 1/5/18 195 0.4 586 650 1/6/18 653 1.5 420 543 1/7/18 187 0.5 645 632 1/8/18 240 0.6 507 546 1/9/18 207 0.8 623 531 1/10/18 311 0.9 511 544 1/11/18 373 1.2 500 639 1/12/18 225 0.5 576 570 1/13/18 276 0.3 540 544 1/14/18 475 0.7 475 674 1/15/18 755 1.1 645 711 1/16/18 732...
Problem Set 2: Pearson’s correlation (7 pts) Research Scenario: Is there a positive relationship between grit...
Problem Set 2: Pearson’s correlation (7 pts) Research Scenario: Is there a positive relationship between grit and GPA in high school seniors? A researcher examined this issue by having students beginning their senior year of high school complete a grit inventory using a Likert-based scale (range 1 – 7), where higher numbers indicate more “grit”. GPA was self-reported (scale 0 – 4.0). Enter the data shown here into SPSS to assess whether there is a positive relationship between grit and...