I only need question 3 done you i have provided the table for that question
Compute th X C Is There A D X C 3.13 Is BNAL 206_A X BNAL 206_A X AL%20206_Assignment%202-Part%202%20(2).pdf 2/3 100% + 3. Problem 3.35 (10%) The file CD Rate contains the yields for one-year CDs and five year CDs, for 39 banks in the United States, as of January 9, 2017. For each type of account: a. Compute the first quartile (Q1), the third quartile (Q3), and the interquartile range. b. List the five-number summary. c. Construct a boxplot and describe its shape. 4. Problem 3.47 (20%) Movie companies need to predict the gross receipts of individual movies once a movie has debuted. The data, stored in PotterMovies, are the first weekend gross, the U.S. gross, and the worldwide gross (in $ millions) of the eight Harry Potter movies. a. Compute the covariance between first weekend gross and U.S. gross, first weekend gross and worldwide gross, and U.S. gross and worldwide gross. b. Compute the coefficient of correlation between first weekend gross and U.S. gross, first weekend gross and worldwide gross, and U.S. gross and worldwide gross. c. Which do you think is more valuable in expressing the relationship between first weekend gross, U.S. gross, and worldwide gross-the covariance or the coefficient of correlation? Explain. d. Based on (a) and (b), what conclusions can you reach about the relationship between first weekend gross, U.S. gross, and worldwide gross? 5. Problem 3.69 (20%) A quality characteristic of interest for a tea-bag-filling process is the weight of the tea in the individual bags. If the bags are underfilled, two problems arise. First, customers may not be able to brew the tea to be as strong as they wish. Second, the company may be in violation of the truth-in-labeling laws. For this product, the label weight on the package indicates that. on average. there are 5.5 grams of tea in a baView Data Review Formulas Visio Data Home Insert Page Layout SmartArt Store Bing Maps My Add-ins Screenshot People Gr Pictures Shapes PivotTable Recommended Table PivotTables Table E13 X V fx D F G H B C E A One-Year Five-Year 1 Bank 1.00 1.60 N 5 Star Bank 1.05 1.66 3 Alostar Bank of Commerce 1.10 Amalgamated Bank 0.50 1.25 AmTrust Bank 0.40 Applied Bank 0.15 0.15 7 Armed Forces Bank N. A. 0.75 1.75 8 Auto Club Trust FSB 1.15 1.75 9 Bank of America 0.05 0.15 10 Blake & Herbert Bank 0.50 0.65 11 BlueHarbor Bank 0.50 0.90 12 BMO Harris Bank NA 0.15 0.75 13 Busey Bank 0.20 0.75 14 California First National Bank 1.26 1.80 15 CBC national Bank 0.45 1.75 16 Discover Bank 1.15 1.76 17 EH National Bank 0.95 1.51 18 E-Loan 1.28 1.80 19 EverBank 1.35 2.28 20 First Internet Bank of Indiana 1.21 2.07 21 First Tennessee Bank NA 0.10 0.55 22 Goildman Sachs Bank USA 1.20 1.85 23 Goldwater Bank 1.07 1.25 24 grantbank 1.06 1.66 25 Grow Financial FCU 0.45 2.00 26 Home Savings Bank 1.00 1.90 27 Live Oak Bank 1.30 1.75 28 Luana Savings Bank 0.80 1.61 29 Patriot Bank 0.30 1.01 30 Pendelton Community Bank 0.35 1.35 31 PNC Bank 0.10 0.55 32 Popular Direct 1.28 2.25 33 Presidential Bank FSB 0.95 34 Radius Bank 1.53 0.25 35 Synchrony 1.00 1.25 36 TD Bank NA 1.85 37 Union Bank 0.25 0.65 0.25 8 Urban Partnership Bank 1.15 39 VirtualBank 0.28 0.70 40 Wells Fargo 1.31 1.81 41 0.05 0.35 42 43 44 Data sol + Ready