this is my data i need to creat a scatter plot on execel and approximate the year that penny composition started to changing . i know how to do the plot i just dont know to find approximation . thanks  Year Mass (g) 1990 2.4822 1994 2.5055 2006 2.5914 1991 2.4852 1998 2.5201 1971 3.1439 1984 2.5132 2006 2.4852 1994 2.5076 1979 3.1024 1975 3.0668 1982 3.0776 2001 2.4873 1989 2.532 1974 3.1034 1980 3.0917 2000 2.4921 1977 3.1057 1993 2.5005 1968 3.0943 1982 3.0761 2000 2.5061 1975 3.093 1981 3.1011 2008 2.489 1987 2.5068 1976 3.1 2010 2.4836 1999 2.5458 2007 2.5015 1987 2.5143 1978 3.0798 1995 2.4947 1974 3.0307 1981 3.0939 1992 2.4737 1982 3.935 1972 3.0973 1993 2.4898 1998 2.4951 1991 2.4756 1995 2.5061 1994 2.4949 2007 2.514 1996 2.4905 2001 2.5073 2002 2.4976 2006 2.5118 1996 2.5159 1972 3.0513 1994 2.4941 1990 2.4832 2007 2.4744 2007 2.4804 1976 3.0947 2001 2.5391 1980 3.0076 1995 2.5061 2004 2.5043 1976 3.0985 1962 3.0758 1975 3.1024 1982 3.0568 1989 2.5135 1973 3.0873 1999 2.5202 2005 2.528 1964 3.1936 1980 3.1235 2009 2.4992 1974 3.0576 1995 2.4895 1993 2.4833 1987 2.4777 1983 2.4757 1990 2.4966 1974 3.0052 1992 2.5066 1971 3.1549 2004 2.529 1979 3.9652 1999 2.4958 1987 2.5137 1967 3.1254 1982 3.0805 1996 2.4924 2007 2.4956 2004 2.5306 2007 2.4772 1989 2.5218 1988 2.5234 2010 2.4983 1980 3.0857 1976 3.103 1977 3.0167 2000 2.48 1996 2.5113 1995 2.5181 1996 2.4888 1977 3.0524

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

this is my data i need to creat a scatter plot on execel and approximate the year that penny composition started to changing . i know how to do the plot i just dont know to find approximation . thanks 

Year Mass (g)
1990 2.4822
1994 2.5055
2006 2.5914
1991 2.4852
1998 2.5201
1971 3.1439
1984 2.5132
2006 2.4852
1994 2.5076
1979 3.1024
1975 3.0668
1982 3.0776
2001 2.4873
1989 2.532
1974 3.1034
1980 3.0917
2000 2.4921
1977 3.1057
1993 2.5005
1968 3.0943
1982 3.0761
2000 2.5061
1975 3.093
1981 3.1011
2008 2.489
1987 2.5068
1976 3.1
2010 2.4836
1999 2.5458
2007 2.5015
1987 2.5143
1978 3.0798
1995 2.4947
1974 3.0307
1981 3.0939
1992 2.4737
1982 3.935
1972 3.0973
1993 2.4898
1998 2.4951
1991 2.4756
1995 2.5061
1994 2.4949
2007 2.514
1996 2.4905
2001 2.5073
2002 2.4976
2006 2.5118
1996 2.5159
1972 3.0513
1994 2.4941
1990 2.4832
2007 2.4744
2007 2.4804
1976 3.0947
2001 2.5391
1980 3.0076
1995 2.5061
2004 2.5043
1976 3.0985
1962 3.0758
1975 3.1024
1982 3.0568
1989 2.5135
1973 3.0873
1999 2.5202
2005 2.528
1964 3.1936
1980 3.1235
2009 2.4992
1974 3.0576
1995 2.4895
1993 2.4833
1987 2.4777
1983 2.4757
1990 2.4966
1974 3.0052
1992 2.5066
1971 3.1549
2004 2.529
1979 3.9652
1999 2.4958
1987 2.5137
1967 3.1254
1982 3.0805
1996 2.4924
2007 2.4956
2004 2.5306
2007 2.4772
1989 2.5218
1988 2.5234
2010 2.4983
1980 3.0857
1976 3.103
1977 3.0167
2000 2.48
1996 2.5113
1995 2.5181
1996 2.4888
1977 3.0524
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman