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 remaining sub-parts to be solved, then please resubmit the whole question and specify those sub-parts you want us to solve. a. The populated table is given by, Using above table values, we have b. ∑i=1nx=133 c. ∑i=1ny=64 d. Here we have 5 observations, hence n=5. e. ∑i=1nxy=1799 f. ∑i=1nx2=3639 g. ∑i=1nx2=1332=17689 h. The regression line is given by y=mx+b where, m=n∑i=1nxy-∑i=1nx∑i=1nyn∑i=1nx2-∑i=1nx2m=5×1799-133×645×3639-17689m=0.9545 b=∑i=1ny-m∑i=1nxnb=64-0.9545×1335b=-12.5909 Hence, the regression line is y=0.9545x-12.5909 i. The coefficient of correlation is given by, r=n∑i=1nxy-∑i=1nx∑i=1nyn∑i=1nx2-∑i=1nx2n∑i=1ny2-∑i=1ny2r=5×1799-133×645×3639-13325×918-642r=0.9661 Using Excel, we get the coefficient of correlation as follows, Go to Data-> Data analysis->Regression->Enter x and y values ->select output range ->ok We get result as follows, Hence, the coefficient of correlation is 0.96607.

Math

Statistics

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

C8. According to the Pew Research Center (2015), recent immigrants are better educated than earlier immigrants to the United States. The change was attributed to the availability of better education in each region or country of origin. The percentage of immigrants 25 years of age and older who completed at least high school is reported in this table for 1970 to 2013. Write a statement describing the change over time in the percentage who completed at least a high school degree. 1970 1980 1990 2000 2013 Mexico 14 17 26 30 48 Other Central/South America 57 53 60 66 Asia 75 72 75 82 84 48 68 81 87 95 Europe 36 48 52 58 72 Caribbean 81 91 88 85 85 Africa Source: Pew Research Center, Modern Immigration Wave Brings 59 Million to U.S., Driving Population Growth and Change Through 2065, 2015. Retrieved from https://www.pewresearch.org/hispanic/2015/09/28/modern- immigration-wave-brings-59-million-to-u-s-driving-population-growth-and-change-through-2065/ 52
Pa 9 10
=48 New Bank (NB) believes that there is a relationship between the kilometres (KM) travelled by its customers and the charges on their credit cards (CC). The bank collected the data given in Table NB Table NB Dollars (US$'00) 18 Kilometres ('00) 12 24 13 20 14 25 17 23 18 23 20 30 21 34 22 31 24 37 24 If a credit card holder should spend US$2.300 on a business trip, how many kilometres would you expect her to travel (to the nearest whole number)? Select one: O a 3,483 O b 1.583 OC. 950 od. 850 11:10 AM 85°F a Q) ENG 12/16/2021 hp EliteBook 8470p Ftay postitve insert pause break scroll 16 D f7 f8 f9 O f10 3 f11 f12 prt sc wm
9. value= The table below lists all 50 states in the United States of America and their 2015 violent crime rates. This rate measures the number of violent crimes in a state per 10,000 people. For instance, if a state had 12,000 violent crimes and a population size 2,300,000, its violent crime rate was $(2,300,00) 10,000 = 52. a. C. d. e. X TABLE 3.2: List of States with 2015 Violent Crime Rates Measured as Number of Violent Crimes per 10.000 Population Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana lowa Kansas Kentucky 43 64 42 46 40 31 26 49 47 37 25 22 38 36 27 34 21 Louisiana 52 Maine 13 Maryland 47 Massachusetts 41 Michigan 45 20 Minnesota 23 24 Mississippi 27 7 Missouri 43 20 Montana 25 Nebraska 26 Nevada 60 New Hampshire 22 New Jersey 29 New Mexico 61 New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington…
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?
industrial workers during the years 1980-87. The consumer price indices for these years with 1980 as base we 10-35. The table given below shows the average wages in rupees per week of a group of are also shown: : 1980 Year Average Wage of Workers (Rs.) . Consumer Price Index () Determine the Real Wage of workers during the years 1980-87 as compared with their wages in 1981 1982 1983 1984 1985 1986 1987 119 133 144 157 175 184 189 194 100 107-6 106-6 107-6 116-2 118-9 119-8 120-2 1980. (ii) Determine the purchasing power of Rupee for the year 1987 as compared te the year 1980. What is the significance of this result ? res
42. In a working class budget enquiry in towns A and B, it was found in 2014 that an average working class family's expenditure on food and other items was as follows : Town A Town B 50% 50% () Food (i) Other items In 2017, the consumer price index stood at 279 for town A, 265 for town B (Base year 2014 = 100). It was known that the rise in the prices of all articles consumed by the working class was the same for A and B. What was the 2017 index for (a) food, and (b) other items ? 64% 36%
Q 3: Al Matra LLC has recently hired Mr. Musab, a professional market researcher. Mr. Musab is interested to find out relationship between cost incurred and revenue earned by the company. He collected the data of last 7 years from the accounts department, but he is confused about the method which can find out the relationship. Revenue Cost Incurred Earned Year (OMR in (OMR in Millions) Millions) 2013 20 2014 10 22 2015 9 22 2016 18 2017 11 20 2018 12 24 2019 10 25 a) Find out the correlation value and give interpretation of the result b) If correlation value is 1.25, discuss the result analytically.
IV. APPLICATION AND ANALYSIS ON QUEUING THEORY. Direction: Given the following assumptions, derive the answer/s for each question. In answering the questions, copy the questions into the Output Area and write your answers after each question. Assumptions: Mean Arrival Rate (2) = 3 customers/hour Number of Ser vers (C ) = 1 Mean Service Rate (U) = 4 customer s/hour 1. Calculate and determine the Occupation Rate. (p) 2. What is the average number in system average (L)? 3. Determine the average system in system (W). 4. What is the average time in queue (Wq)? 5. Determine the length of queue (Lq). Capacity Demand p = Available Capacity u =- L=p/(1- p) Lq= p2/(1- p) = L-p W=LA=1/(u- 2) We-Lψλ- λ( μ(μ- λ)