EXCEL HOMEWORK ATTACHING THE FILE! 4-19 on page 141. 4-30 on page 143. 4-32 on pages 143-144. 5-28 on page 179. 5-35 on page 180. 4-19 on page 141. 4-30 on page 143. 4-32 on pages 143-144. 5-28 on p
4-19 on page 141.4- 30 on page 143.
4-32 on pages 143- 144.
5-28 on page 179.
5- 35 on page 180.
4-19 Bus and subway ridership in Washington, D.C., during the summer months is believed to be heavily tied to the number of tourists visiting the city. During the past 12 years, the following data have been obtained:
(a) Plot these data and determine whether a linear model is reasonable. (b) Develop a regression model. (c) What is expected ridership if 10 million tourists visit the city?
YEAR NUMBER OF TOURISTS (1,000,000s) RIDERSHIP (1000,000’S) RY sY R,Y (Y (Y RSY IY QY RIY EY EY R,Y ,Y REY (,Y QY R,Y (sY sY RQY (EY 0Y R(Y (SY Y REY (sY RSY (SY EEY RRY R,Y IEY R(Y sY RsY 4-30 In 2012, the total payroll for the New York Yankees was almost $200 million, while the total payroll for the Oakland Athletics (a team known for using baseball analytics or sabermetrics) was about $55 million, less than one-third of the Yankees’ payroll. In the following table, you will see the payrolls (in millions) and the total number of victories for the baseball teams in the American League in the 2012 season. Develop a regression model to predict the total number of victories based on the payroll. Use the model to predict the number of victories for a team with a payroll of $79 million. Based on the results of the computer output, discuss the relationship be-tween payroll and victories. Team Payroll ($1,000,000s) Number of Victories )BfombNaFYSamNfF1 Y 0RTEY IY )N1oNUYXFHYYN2Y RsIT(Y Q Y uymcBONYrymoFYYN2 Y QT Y 0,Y ufFVFfBUHY3UHmBU1 Y s0TEY Q0Y $FoaNmoYZmOFa1Y RI(TIY 00Y [BU1B1YumoeYXNeBf1 Y QST Y s(Y VN1YTUOFfF1YTUOFf1 Y R,ET,Y 0 Y \mUUF1NoBYZ’mU1 Y ETRY QQY 4F’YPNaQYPBUQFF1 Y R 0TSY ,Y SBQfBUHYToyfFomc1 Y ,,TEY EY YFBoofFY\BamUFa1Y 0(TSY s,Y ZBbMBY)BeYXBe1 Y QET(Y SY ZF2B1YXBUOFa1 Y R(ST,Y IY ZNaNUoNY)fDFY]Be1 Y s,T,Y sIY 4-32 The closing stock price for each of two stocks was recorded over a 12- month period. The closing price for the Dow Jones Industrial Average (DJIA) was also recorded over this same time period.
These values are shown in the following table: MONTH DIJA STOCK 1 STOCK 2 RY RRlRQ0Y E0T,Y I(TEY (Y RRlR,SY E0T(Y IRTsY IY RRlR0QY EET,Y IRT Y EY RRlI0RY EETsY IQTQY ,Y RRlQs Y E TIY IQTsY QY R(lS0RY E TIY I0TsY sY R(l(((Y EQTRY I T,Y 0Y R(lEQIY EQT(Y ERT(Y Y R(lQ((Y EsTsY EITIY RSY R(l(Q Y E0TIY I TEY RRY R(lI,EY EsTSY ESTRY R(Y RIlSQIY EsT Y E(TRY RIY RIlI(QY EsT0Y E,T(Y JBC $FVFfNM YB YaFOaF11mNU YbNHFf YoN YMaFHmco YoyF YMamcFY NiY1oNcQY RYPB1FHY NUYoyF Y$N’Y ]NUF1Y 3UHD1oamBf TVFaBOFT JPC $FVFfNM YB YaFOaF11mNU YbNHFf YoN YMaFHmco YoyF YMamcFY NiY1oNcQY (YPB1FHY NUYoyF Y$N’Y ]NUF1Y 3UHD1oamBf TVFaBOFT JcC rymcyYNi YoyF Yo’N Y1oNcQ1Y m1YbN1o YymOyfe YcNaaFfBoFH YoN YoyF Y$N’Y ]NUF1Y 3UHD1oamBfY TVFaBOFYNVFa Yoym1 YombF MFamNHL 5-28 Sales of industrial vacuum cleaners at R. Lowenthal Supply Co. over the past 13 months are as follows:
SALES ($1,000s) MONTH SALES ($1,000s) MONTHS RRY ]BUDBaeY REY TDOD1oY REY ^FPaDBae Y RsY YFMoFbPFa Y RQY \BacyY R(Y ScoNPFa Y RSY TMamfY REY 4NVFbPFa Y R,Y \BeY RQY $FcFbPFa Y RsY ]DUF Y RRY ]BUDBaeY RRY ]DfeY JBC W1mUOYB YbNVmUO YBVFaBOFY ’moyYoyaFF YMFamNH1l YHFoFabmUF YoyF YHFbBUHY iNaYVBcDDb YcfFBUFa1 YiNa YUF2o ^FPaDBaeT JPC W1mUO YB Y’FmOyoFH YbNVmUO YBVFaBOFY ’moyYoyaFF YMFamNH1l YHFoFabmUF YoyF YHFbBUHY iNaYVBcDDb YcfFBUFa1 YiNa ^FPaDBaeTY W1FYIlY(l YBUHY RYiNaY oyFY ’FmOyo1 YNi YoyFY bN1o YaFcFUol Y1FcNUHY bN1oYaFcFUol YBUHY oymaH YbN1o YaFcFU o MFamNH1l YaF1MFcomVFfeTY ^NaYF2BbMfFl Ymi YeND Y’FaF YiNaFcB1omUO YoyF YHFbBUHY iNaY^FPaDBael Y4NVFbPFa Y’NDfH yBVFY BY’FmOyo YNi YRl Y$FcFbPFa Y’NDfH YyBVFY BY’FmOyo YNi Y(l YBUHY ]BUDBae Y’NDfH YyBVFY BY’FmOyo YNi YIT JcC _VBfDBoF YoyFY BccDaBceY NiYFBcyY NiYoyF1FY bFoyNH1T JHC ryBoYNoyFa YiBcoNa1Y bmOyoYXT YVN’FUoyBf YcNU1mHFaY mUYiNaFcB1omUO Y1BfF1L 5-35 A major source of revenue in Texas is a state sales tax on certain types of goods and services. Data are com -piled, and the state comptroller uses them to project future revenues for the state budget.
One particular category of goods is classified as Retail Trade. Four years of quarterly data (in $1,000,000s) for one particular area of southeast Texas follow: QUARTER YEAR 1 YEAR 2 YEAR 3 YEAR 4 RY (R0Y ((,Y (IEY (,SY (Y (EsY (,EY (Q,Y (0IY IY (EIY (,,Y (QEY (0 Y EY ( (Y ( Y I(sY I,QY JBC uNbMDoFYBY1FB1NUBf YmUHF2 YiNaY FBcyY aDBaoFaY PB1FHYNUYBYu\TT JPC $F1FB1NUBfmbF YoyFY HBoBY BUHYHFVFfNM YB YoaFUHY fmUFYNUY oyFY HF1FB1NUBfmbFH YHBoBT JcC W1FY oyFYoaFUHY fmUFYoN YiNaFcB1o YoyFY 1BfF1Y iNaYFBcyY aDBaoFaY NiYeFBaY ,T JHC W1FYoyFY1FB1NUBf YmUHmcF1 YoN YBH`D1o YoyFY iNaFcB1o1 YiNDUHY mUYMBaoY JcCYoNYNPoBmUY oyFYimUBf YiNaFcB1o1T