ABCEKLMNA common perception is that airline profits are strongly correlated with the price of oil. The Following are annualnet incomes of American Airlines together with the approximate price of oil in the period 2005-2010:3a. Populate the tableAmerican NetIncome (Smillion) (y)Barrel Oil ($)Yearху(x)4.5.1200556-85062006632507.32007674508.4200892-2100200954-1450106.201071-70011121314b. What is Ex?1516c. What is Ey1718d. What is n?1920e. What is Exy2122£. What is (Ex²)2324g. What is (Ex)2526h. Obtain a regression line (obtain the coefficients) showing American's net income as a function of the price of oil272829303132 i. Obtain the coefficient of correlation r333435Use the data analysis tool in Excel to obtain the coefficients in part 1(h). Copy and Paste your regression output37 below.363839 fxAB.DG39K2. The following table shows U.S. exports to a certain country as a function of U.S. imports from thatsame country, based on trade figures in the period 1990-2003.4041 a. Populate the tableImports (Sbillions) (x)Exports ($billions) (y)42хуy4322744241045271546352520471248495051b. What is Ex?5253c. What is Ey5455d. What is n?5657e. What is Exy5859£. What is (Ex²)6061g. What is (Ex)²6263h. Obtain a regression line (obtain the coefficients) showing American's imports as a function of exports646566m67b =6869 i. Obtain the coefficient of correlation r7071numerator =72denominator -737475j. Use the data analysis tool in Excel to obtain the coefficient of correlation in part 2(i).Copy and Paste your regression output below.76777879L

Hello. Since your question has multiple parts, we will solve first question for you. If you want…

2. The following table shows U.S. exports to a certain country as a function of U.S. imports from that same country, based on trade figures in the period 1990-2003. a. Populate the table Imports (S billions) (x) Еxports (S billions) (y) ху 22 24 10 27 15 35 20 25 12 b. What is Ex? c. What is Ey d. What is n? e. What is Exy £. What is (Ex²) g. What is (Ex)² h. Obtain a regression line (obtain the coefficients) showing American's imports as a function of exports i. Obtain the coefficient of correlation r numerator denominator j. Use the data analysis tool in Excel to obtain the coefficient of correlation in part 2(i). Copy and Paste your regression output below.

2. The following table shows U.S. exports to a certain country as a function of U.S. imports from that same country, based on trade figures in the period 1990-2003. a. Populate the table Imports (S billions) (x) Еxports (S billions) (y) ху 22 24 10 27 15 35 20 25 12 b. What is Ex? c. What is Ey d. What is n? e. What is Exy £. What is (Ex²) g. What is (Ex)² h. Obtain a regression line (obtain the coefficients) showing American's imports as a function of exports i. Obtain the coefficient of correlation r numerator denominator j. Use the data analysis tool in Excel to obtain the coefficient of correlation in part 2(i). Copy and Paste your regression output below.

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

9. The chief executive of Rex Cars wants to investigate the relationship between the number of new car sales and the amount of money spent on advertising. She collects data from company records on the number of new car sales, y, and the cost of advertising each year, x (£000). The data are shown in the table below. Cost of advertising (£000), (x) Number of new car sale, Year (y) 2005 120 4240 2006 126 4380 2007 132 4420 2008 134 4440 2009 137 4430 2010 144 4520 2011 148 4590 2012 150 4660 2013 153 4700 2014 158 4790 a. Use your calculator to find the equation, y = a + bx, of the line of best fit (the least squares regression line of y on x). b. Interpret the value of a. c. Calculate the predicted number of car sales made in 2015 if the company spends £163 000 on advertising.
how do i describe the relationship of this scatterplot?
Relate how the independent and dependent variables affect each other.
Help me fast so that I will give Upvote.
6. The Motion Picture Association of America reports a drop-off of video disc sales. The data in the table below shows consumer spending on video discs (DVD, Blue-ray, and UltraHD Blu-ray) in the United States in the years 2015-2018. Year Consumer Spending on video discs (in billions of dollars) 2015 9.1 2016 8.0 2017 6.8 2018 5.8 (a) What was the average rate of change in consumer spending from 2015 to 2018? (Be sure to include units.) (b) Use the average rate of change calculated above to predict consumer spending on video discs in 2020?
2. The table below gives the sales, S, of Intel Corporation, a leading manufacturer of integrated circuits. 2003 30,100 2004 34,200 2006 2007 2008 Year S (millions of $) 2005 38,800 35,400 38,300 37,600 a. Find the change in sales between 2005 and 2006. b. Find and interpret the average rate of change in sales between 2005 and 2006.
Assuming equal effort (# of nets in the water has not changed and the fishing season dates have stayed the same) identify trends in the squid population you see in the data. Based on your textbook reading this week, speculate what processes or dynamics could produce the population trends seen in your data.
2. What features V Good Presentation Bad Presentation of the 'Good Minimum Wage Minimum Wage $ 1960: $1.00 Presentation' 1970: $1.60 make it better than the ' Bad 2 1980: $3.10 1990: $3.80 1960 1970 1980 1990 Presentation'? A. Bad Presentation V Good Presentation Quarterly Sales Quarterly Sales 2. 200 %24 50 100 Q1 Q2 Q3 04 01 02 03 04 B. w 26°C ヘ 25
8. Magazine Sales The following table shows the income, measured in thousands of dollars, from sales of a certain magazine at the start of the given year.
56. From the following data calculate the cost of living index number by the family budget mehtod. Also obtain the expenditure of the person in the year 2013 if his ex- penditure is 2010 is Rs. 600. Price 2010 Price 2013 Weight Group Food Clothing Rent 12 60 16 32 30 60 30 10 10 20 15 Education Misc. 15 10