Final 2 different part of homework

profilehuang1783218
Lab5_Econ130.xlsx

Questions

Lab 4
Complete the following steps below in the corresponding tab
Correlation
Life Expectancy vs High School Graduation Rates
1) Construct a scatterplot using life expectancy and individuals who completed 4 years of high school ***LABEL AXES AND TITLE THE SCATTERPLOT***
2) Insert a trendline in the scatterplot
3) Format the axes so that the data fit in the area of the scatterplot
***HINT*** Right click the x axis on the scatterplot -> Format Axis -> Change the minimum and maximum bounds. Repeat for y axis
4) Answer the questions below the scatterplot
Movie Ratings vs Movie Budgets
1) Construct a scatterplot using critics ratings and audience ratings ***LABEL AXES AND TITLE THE SCATTERPLOT***
2) Insert a trendline in the scatterplot
3) Format the axes so that the data fit in the area of the scatterplot
***HINT*** Right click the x axis on the scatterplot -> Format Axis -> Change the minimum and maximum bounds. Repeat for y axis
4) Answer the questions below the scatterplots
Note: The data obtained for this lab were downloaded from https://www.informationisbeautiful.net/data/

Life Expectancy and School

Country Year Life expectancy at birth, total (years) (years) People who Completed 4 years of High School (In Thousands)
United States 1970 70.81 37,134 Insert Scatter Plot Here:
United States 1971 71.11 38,029
United States 1972 71.16 39,171
United States 1973 71.36 40,448
United States 1974 71.96 41,460
United States 1975 72.60 42,353
United States 1976 72.86 43,157
United States 1977 73.26 43,602
United States 1978 73.36 44,381
United States 1979 73.80 45,915
United States 1980 73.61 47,934
United States 1981 74.01 49,915
United States 1982 74.36 51,426
United States 1983 74.46 52,060
United States 1984 74.56 54,073
United States 1985 74.56 54,866
United States 1986 74.61 56,338
United States 1987 74.77 57,669
United States 1988 74.77 58,940
United States 1989 75.02 59,336
United States 1990 75.21 60,119
United States 1991 75.37 61,272
United States 1992 75.62 57,860
United States 1993 75.42 57,589
United States 1994 75.62 56,515
United States 1995 75.62 56,450
United States 1996 76.03 56,559
United States 1997 76.43 57,586
United States 1998 76.58 58,174
United States 1999 76.58 57,935
United States 2000 76.64 58,086
United States 2001 76.84 58,272
United States 2002 76.94 58,456 Questions Answers
United States 2003 77.04 59,292 Use the =correl() function to find the correlation coefficient of life expectancy vs education. Round to two decimal places
United States 2004 77.49 59,811
United States 2005 77.49 60,893 Is this a positive or a negative correlation? What is the strength of the correlation?
United States 2006 77.69 60,898
United States 2007 77.99 61,490 Give at least two possible explanations as to why life expectancy at birth correlates with people who completed 4 years of high school
United States 2008 78.04 61,183
United States 2009 78.39 61,626
United States 2010 78.54 62,456
United States 2011 78.64 61,911
United States 2012 78.74 62,113
United States 2013 78.74 61,704
United States 2014 78.84 62,240
United States 2015 78.69 62,575
United States 2016 78.69 62,002

Movie Data

Film Rotten Tomatoes critics % Rotten Tomatoes Audience % % gap Budget ($million) Year Genre
Kill Your Darlings 76 60 16 2 2013 Biography, Drama, Thriller, Romance Insert Critic Ratings vs Audience Ratings scatterplot here:
Boyhood 97 81 16 4 2014 drama
Cloudy w/ Chance of Meatballs 87 71 16 100 2009 animation, comedy, family
Gravity 96 80 16 100 2013 Sci-Fi, Drama, Mystery, Thriller
The Gift 92 75 17 5 2015 thriller
W. 59 42 17 25.1 2008 biography, history
Walk Hard 74 57 17 35 2007 comedy
Frankenweenie 87 70 17 39 2012 animation, comedy, family
Obvious Child 90 72 18 1 2014 comedy, romance
Manchester by the Sea 95 77 18 9 2016 Drama
Daybreakers 67 49 18 20 2010 action, horror
The World's End 89 71 18 20 2013 Action, Sci-Fi, Comedy
Tinker Tailor Soldier Spy 83 65 18 21 2011 mystery, thriller
The Grey 79 61 18 25 2012 action, adventure
The Cabin in the Woods 92 74 18 30 2012 horror, mystery, thriller
Neighbors 2 62 44 18 35 2016 Comedy
Rango 87 69 18 135 2011 animation, adventure, comedy
The BFG 75 57 18 140 2016 Adventure
Winter's Bone 94 75 19 2 2010 drama
Inside Llewyn Davis 93 74 19 11 2013 Drama, Music
The Shallows 78 59 19 17 2016 Drama
Shaun the Sheep Movie 99 80 19 25 2015 animation
American Hustle 93 74 19 40 2013 Drama, History, Thriller, Crime
The Diary of a Teenage Girl 94 74 20 2 2015 drama
The Kids Are All Right 93 73 20 4 2010 comedy Insert Audience Ratings vs Movie Budget scatterplot here:
Magic Mike 80 60 20 7 2012 comedy
Hope Springs 75 55 20 30 2012 comedy, romance
Nanny McPhee Returns 75 55 20 35 2010 comedy, family, fantasy
Lucy 67 47 20 40 2014 action, sci-fi, thriller
The Other Guys 78 58 20 100 2010 action, comedy, crime
Carol 94 73 21 12 2016 Drama
Foxcatcher 87 66 21 24 2014 drama
Michael Clayton 90 69 21 25 2007 thriller
Beowulf 71 50 21 150 2007 animation
Colossal 80 59 21 15 2017
Tangerine 97 75 22 0 2015 comedy, drama
Please Give 86 64 22 3 2010 comedy
Rachel Getting Married 84 62 22 12 2008 romance
Into the Woods 71 49 22 50 2014 adventure, fantasy, comedy, family, musical
Muppets Most Wanted 80 58 22 50 2014 adventure, comedy, crime, family, musical
The International 59 37 22 50 2009 action, crime, mystery
Contagion 84 62 22 60 2011 sci-fi, thriller
Ghostbusters 74 52 22 144 2016 Comedy
Don Jon 81 58 23 3 2013 Drama, Comedy, Romance
Everything Must Go 75 52 23 5 2011 comedy
A Serious Man 90 67 23 7 2009 comedy
Keanu 78 55 23 15 2016 Comedy
Appaloosa 77 54 23 20 2008 crime, western
Barbershop: The Next Cut 90 67 23 20 2016 Comedy Questions Answers
Anchorman 2 75 52 23 50 2013 Comedy Use the =correl() function to find the correlation coefficient of critic ratings vs audience ratings. Round to two decimal places
The Lobster 88 64 24 4.5 2016 romance, comedy
The Master 85 61 24 32 2012 drama Is this a positive or a negative correlation? What is the strength of the correlation?
The Tree Of Life 84 60 24 32 2011 fantasy
Indiana Jones IV 77 53 24 185 2008 action, adventure, Use the =correl() function to find the correlation coefficient of audience ratings vs the movie budget. Round to two decimal places
Grandma 92 67 25 1 2015 comedy
Experimenter 86 61 25 3 2015 drama Is this a positive or a negative correlation? What is the strength of the correlation?
Extract 63 38 25 8 2009 comedy, crime, romance
Ouija: Origin of Evil 82 57 25 9 2016 Horror What is the average budget for a movie from this dataset? Round to two decimal places
Arbitrage 87 62 25 12 2012 thriller
Captain Underpants 86 61 25 38 2017 What is the mode for the ratings given by critics?
The Babadook 98 72 26 2.5 2014 horror
Ghost Town 86 60 26 20 2008 comedy, fantasy, romance
The Pirates! Band of Misfits 86 60 26 55 2012 animation, adventure, comedy
Spongebob: Sponge Out of Water 80 54 26 74 2015 animation
Paranormal Activity 83 56 27 0.015 2009 horror, mystery
Cedar Rapids 86 59 27 10 2011 comedy
Brüno 68 41 27 42 2009 comedy
Duplicity 64 37 27 60 2009 crime, romance, thriller
Cyrus 81 53 28 7 2010 romance
Adventureland 89 61 28 10 2009 comedy, romance
The American 66 38 28 20 2010 crime, thriller
Killing Them Softly 74 44 30 15 2012 crime, thriller
Drag Me to Hell 92 62 30 30 2009 horror, thriller
The Beguiled 78 48 30 10 2017
The Lost City of Z 87 57 30 30 2017
It Follows 97 66 31 2 2015 horror
Solitary Man 80 49 31 15 2010 comedy, romance
Piranha 3-D 74 43 31 24 2010 comedy, horror
Sausage Party 82 50 32 19 2016 Comedy
Norman 88 56 32 5.2 2017
Greenberg 75 42 33 25 2010 comedy, romance
The Witch 91 57 34 3 2016 Horror
Noah 76 41 35 125 2014 action, adventure, drama, fantasy
The Informant! 79 43 36 22 2009 comedy, crime
The Last Jedi 93 57 36 300 2017 sci-fi, adventure
The Last Exorcism 71 34 37 1.8 2010 horror, thriller
Love & Friendship 98 60 38 3 2016 Drama
Stop-Loss 65 27 38 25 2008 war
Mr. Turner 98 58 40 8.5 2014 drama, biography, history
Hail, Caesar! 85 45 40 22 2016 Comedy
Haywire 80 40 40 23 2012 action, thriller
It Comes At Night 88 43 45 2.4 2017