QUESTION : Produce a scatter plot (showing trend line, linear equation and R-squared) using Excel, to show the relationship between earnings and money spent on mobile phone for female students. Then interpret the linear equation and R-squared in the scatter plot for female students. DATA: Gender Earnings Bill Female 3000 150 Female 1000 45 Female 1300 100 Female 3000 120 Female 1000 45 Female 0 600 Female 1500 100 Female 800 40 Female 2600 90 Female 1500 30 Female 1123.6 38 Female 1500 145 Female 1500 230 Female 1000 100 Female 4000 100 Female 800 40 Female 250 90 Female 1000 45 Female 1000 120 Female 1400 41 Female 1700 200 Female 1450 79 Female 1600 50 Female 800 40 Female 1500 103 Female 1500 35 Female 250 55 Female 100 95 Female 1000 30 Female 1300 150 Female 1500 26 Female 1300 70 Female 2200 100 Female 1500 50 Female 2500 100 Female 145 35 Female 1200 143 Female 600 90 Female 5000 100 Female 1600 90 Female 1000 40 Female 2600 49 Female 3200 44.95 Female 3010 30 Female 400 40 Female 1000 40 Female 1000 170 Female 1000 80 Female 0 40 Female 2000 40 Female 600 85 Female 0 25 Female 2000 120 Female 0 90 Female 2000 40 Female 1300 85 Female 1800 80 Female 800 80 Female 1200 40 Female 1500 60 Female 600 50 Female 850 70 Female 1000 45 Female 160 40 Female 350 50 Female 1800 60 Female 1500 50 Female 1500 40 Female 1000 20 Female 1500 120 Female 900 60 Female 600 18 Female 1750 45 Female 1500 39.99 Female 600 50 Female 4000 100 Female 900 110 Female 2500 60 Female 1500 50 Female 800 30 Female 1000 50 Female 600 30 Female 920 120 Female 500 30 Female 700 30 Female 4000 75 Female 500 27 Female 1400 80 Female 2000 100 Female 500 15 Female 800 100 Female 1000 70 Female 2000 120 Female 3000 60 Female 3384 90 Female 650 80 Female 250 30 Female 20 40 Female 2500 50 Female 800 40 Female 2000 100 Female 500 35 Female 1940 40 Female 1000 90 Female 2300 50 Female 650 90 Female 600 40 Female 1600 40 Female 1000 30 Female 80 30 Female 550 30 Female 500 60 Female 100 95 Female 800 50 Female 1200 120 Female 800 38 Female 1000 100 Female 1500 30 Female 2000 109 Female 1000 40 Female 50 40 Female 1700 100 Female 2300 100 Female 1000 40 Female 2500 40 Female 850 75 Female 600 30 Female 500 30 Female 400 50 Female 3500 100 Female 2800 40 Female 1000 30 Female 1200 113 Female 200 30 Female 1500 40 Female 5000 150 Female 840 138 Female 960 30 Female 200 29 Female 1300 50 Female 200 20 Female 1500 70 Female 400 45 Female 30 30 Female 1064 30 Female 1500 110 Female 6107.36 139 Female 1000 30 Female 500 110 Female 3000 140 Female 100 45 Female 1000 30 Female 60 80 Female 880 100 Female 280 100 Female 2400 87 Female 1000 30 Female 200 30 Female 500 40 Female 800 70 Female 5000 100 Female 800 20 Female 0 20 Female 1060 40 Female 2000 60 Female 0 10 Female 1000 35 Female 1000 20 Female 600 40 Female 350 10 Female 600 32 Female 2500 50 Female 270 50 Female 0 5 Female 100 30 Female 1000 200 Female 3000 45 Female 400 50 Female 2000 40 Female 700 80 Female 2600 39 Female 2400 90 Female 3000 25 Female 1100 85 Female 500 40 Female 3000 40 Female 880 80 Female 2000 80 Female 1800 45 Female 380 250 Female 500 40 Female 3000 80 Female 200 20 Female 2000 100 Female 1628.7 120 Female 1000 30 Female 0 35 Female 295 4 Female 200 0 Female 900 30 Female 500 40 Female 200 30
QUESTION : Produce a scatter plot (showing trend line, linear equation and R-squared) using Excel, to show the relationship between earnings and money spent on mobile phone for female students. Then interpret the linear equation and R-squared in the scatter plot for female students. DATA: Gender Earnings Bill Female 3000 150 Female 1000 45 Female 1300 100 Female 3000 120 Female 1000 45 Female 0 600 Female 1500 100 Female 800 40 Female 2600 90 Female 1500 30 Female 1123.6 38 Female 1500 145 Female 1500 230 Female 1000 100 Female 4000 100 Female 800 40 Female 250 90 Female 1000 45 Female 1000 120 Female 1400 41 Female 1700 200 Female 1450 79 Female 1600 50 Female 800 40 Female 1500 103 Female 1500 35 Female 250 55 Female 100 95 Female 1000 30 Female 1300 150 Female 1500 26 Female 1300 70 Female 2200 100 Female 1500 50 Female 2500 100 Female 145 35 Female 1200 143 Female 600 90 Female 5000 100 Female 1600 90 Female 1000 40 Female 2600 49 Female 3200 44.95 Female 3010 30 Female 400 40 Female 1000 40 Female 1000 170 Female 1000 80 Female 0 40 Female 2000 40 Female 600 85 Female 0 25 Female 2000 120 Female 0 90 Female 2000 40 Female 1300 85 Female 1800 80 Female 800 80 Female 1200 40 Female 1500 60 Female 600 50 Female 850 70 Female 1000 45 Female 160 40 Female 350 50 Female 1800 60 Female 1500 50 Female 1500 40 Female 1000 20 Female 1500 120 Female 900 60 Female 600 18 Female 1750 45 Female 1500 39.99 Female 600 50 Female 4000 100 Female 900 110 Female 2500 60 Female 1500 50 Female 800 30 Female 1000 50 Female 600 30 Female 920 120 Female 500 30 Female 700 30 Female 4000 75 Female 500 27 Female 1400 80 Female 2000 100 Female 500 15 Female 800 100 Female 1000 70 Female 2000 120 Female 3000 60 Female 3384 90 Female 650 80 Female 250 30 Female 20 40 Female 2500 50 Female 800 40 Female 2000 100 Female 500 35 Female 1940 40 Female 1000 90 Female 2300 50 Female 650 90 Female 600 40 Female 1600 40 Female 1000 30 Female 80 30 Female 550 30 Female 500 60 Female 100 95 Female 800 50 Female 1200 120 Female 800 38 Female 1000 100 Female 1500 30 Female 2000 109 Female 1000 40 Female 50 40 Female 1700 100 Female 2300 100 Female 1000 40 Female 2500 40 Female 850 75 Female 600 30 Female 500 30 Female 400 50 Female 3500 100 Female 2800 40 Female 1000 30 Female 1200 113 Female 200 30 Female 1500 40 Female 5000 150 Female 840 138 Female 960 30 Female 200 29 Female 1300 50 Female 200 20 Female 1500 70 Female 400 45 Female 30 30 Female 1064 30 Female 1500 110 Female 6107.36 139 Female 1000 30 Female 500 110 Female 3000 140 Female 100 45 Female 1000 30 Female 60 80 Female 880 100 Female 280 100 Female 2400 87 Female 1000 30 Female 200 30 Female 500 40 Female 800 70 Female 5000 100 Female 800 20 Female 0 20 Female 1060 40 Female 2000 60 Female 0 10 Female 1000 35 Female 1000 20 Female 600 40 Female 350 10 Female 600 32 Female 2500 50 Female 270 50 Female 0 5 Female 100 30 Female 1000 200 Female 3000 45 Female 400 50 Female 2000 40 Female 700 80 Female 2600 39 Female 2400 90 Female 3000 25 Female 1100 85 Female 500 40 Female 3000 40 Female 880 80 Female 2000 80 Female 1800 45 Female 380 250 Female 500 40 Female 3000 80 Female 200 20 Female 2000 100 Female 1628.7 120 Female 1000 30 Female 0 35 Female 295 4 Female 200 0 Female 900 30 Female 500 40 Female 200 30
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
QUESTION : Produce a
DATA:
Gender | Earnings | Bill |
Female | 3000 | 150 |
Female | 1000 | 45 |
Female | 1300 | 100 |
Female | 3000 | 120 |
Female | 1000 | 45 |
Female | 0 | 600 |
Female | 1500 | 100 |
Female | 800 | 40 |
Female | 2600 | 90 |
Female | 1500 | 30 |
Female | 1123.6 | 38 |
Female | 1500 | 145 |
Female | 1500 | 230 |
Female | 1000 | 100 |
Female | 4000 | 100 |
Female | 800 | 40 |
Female | 250 | 90 |
Female | 1000 | 45 |
Female | 1000 | 120 |
Female | 1400 | 41 |
Female | 1700 | 200 |
Female | 1450 | 79 |
Female | 1600 | 50 |
Female | 800 | 40 |
Female | 1500 | 103 |
Female | 1500 | 35 |
Female | 250 | 55 |
Female | 100 | 95 |
Female | 1000 | 30 |
Female | 1300 | 150 |
Female | 1500 | 26 |
Female | 1300 | 70 |
Female | 2200 | 100 |
Female | 1500 | 50 |
Female | 2500 | 100 |
Female | 145 | 35 |
Female | 1200 | 143 |
Female | 600 | 90 |
Female | 5000 | 100 |
Female | 1600 | 90 |
Female | 1000 | 40 |
Female | 2600 | 49 |
Female | 3200 | 44.95 |
Female | 3010 | 30 |
Female | 400 | 40 |
Female | 1000 | 40 |
Female | 1000 | 170 |
Female | 1000 | 80 |
Female | 0 | 40 |
Female | 2000 | 40 |
Female | 600 | 85 |
Female | 0 | 25 |
Female | 2000 | 120 |
Female | 0 | 90 |
Female | 2000 | 40 |
Female | 1300 | 85 |
Female | 1800 | 80 |
Female | 800 | 80 |
Female | 1200 | 40 |
Female | 1500 | 60 |
Female | 600 | 50 |
Female | 850 | 70 |
Female | 1000 | 45 |
Female | 160 | 40 |
Female | 350 | 50 |
Female | 1800 | 60 |
Female | 1500 | 50 |
Female | 1500 | 40 |
Female | 1000 | 20 |
Female | 1500 | 120 |
Female | 900 | 60 |
Female | 600 | 18 |
Female | 1750 | 45 |
Female | 1500 | 39.99 |
Female | 600 | 50 |
Female | 4000 | 100 |
Female | 900 | 110 |
Female | 2500 | 60 |
Female | 1500 | 50 |
Female | 800 | 30 |
Female | 1000 | 50 |
Female | 600 | 30 |
Female | 920 | 120 |
Female | 500 | 30 |
Female | 700 | 30 |
Female | 4000 | 75 |
Female | 500 | 27 |
Female | 1400 | 80 |
Female | 2000 | 100 |
Female | 500 | 15 |
Female | 800 | 100 |
Female | 1000 | 70 |
Female | 2000 | 120 |
Female | 3000 | 60 |
Female | 3384 | 90 |
Female | 650 | 80 |
Female | 250 | 30 |
Female | 20 | 40 |
Female | 2500 | 50 |
Female | 800 | 40 |
Female | 2000 | 100 |
Female | 500 | 35 |
Female | 1940 | 40 |
Female | 1000 | 90 |
Female | 2300 | 50 |
Female | 650 | 90 |
Female | 600 | 40 |
Female | 1600 | 40 |
Female | 1000 | 30 |
Female | 80 | 30 |
Female | 550 | 30 |
Female | 500 | 60 |
Female | 100 | 95 |
Female | 800 | 50 |
Female | 1200 | 120 |
Female | 800 | 38 |
Female | 1000 | 100 |
Female | 1500 | 30 |
Female | 2000 | 109 |
Female | 1000 | 40 |
Female | 50 | 40 |
Female | 1700 | 100 |
Female | 2300 | 100 |
Female | 1000 | 40 |
Female | 2500 | 40 |
Female | 850 | 75 |
Female | 600 | 30 |
Female | 500 | 30 |
Female | 400 | 50 |
Female | 3500 | 100 |
Female | 2800 | 40 |
Female | 1000 | 30 |
Female | 1200 | 113 |
Female | 200 | 30 |
Female | 1500 | 40 |
Female | 5000 | 150 |
Female | 840 | 138 |
Female | 960 | 30 |
Female | 200 | 29 |
Female | 1300 | 50 |
Female | 200 | 20 |
Female | 1500 | 70 |
Female | 400 | 45 |
Female | 30 | 30 |
Female | 1064 | 30 |
Female | 1500 | 110 |
Female | 6107.36 | 139 |
Female | 1000 | 30 |
Female | 500 | 110 |
Female | 3000 | 140 |
Female | 100 | 45 |
Female | 1000 | 30 |
Female | 60 | 80 |
Female | 880 | 100 |
Female | 280 | 100 |
Female | 2400 | 87 |
Female | 1000 | 30 |
Female | 200 | 30 |
Female | 500 | 40 |
Female | 800 | 70 |
Female | 5000 | 100 |
Female | 800 | 20 |
Female | 0 | 20 |
Female | 1060 | 40 |
Female | 2000 | 60 |
Female | 0 | 10 |
Female | 1000 | 35 |
Female | 1000 | 20 |
Female | 600 | 40 |
Female | 350 | 10 |
Female | 600 | 32 |
Female | 2500 | 50 |
Female | 270 | 50 |
Female | 0 | 5 |
Female | 100 | 30 |
Female | 1000 | 200 |
Female | 3000 | 45 |
Female | 400 | 50 |
Female | 2000 | 40 |
Female | 700 | 80 |
Female | 2600 | 39 |
Female | 2400 | 90 |
Female | 3000 | 25 |
Female | 1100 | 85 |
Female | 500 | 40 |
Female | 3000 | 40 |
Female | 880 | 80 |
Female | 2000 | 80 |
Female | 1800 | 45 |
Female | 380 | 250 |
Female | 500 | 40 |
Female | 3000 | 80 |
Female | 200 | 20 |
Female | 2000 | 100 |
Female | 1628.7 | 120 |
Female | 1000 | 30 |
Female | 0 | 35 |
Female | 295 | 4 |
Female | 200 | 0 |
Female | 900 | 30 |
Female | 500 | 40 |
Female | 200 | 30 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman