- Perform hypothesis testing to verify the claims that the engineering team has made about the specifications (mileage and top speed) of the Rocinante36 and Marengo32 models.
- Build multiple regression models to predict the sales for Rocinante36 and Marengo32. Choose a model that will generate maximum profit for the company.
Analyse the data provided in the files DataExhibit 1 and DataExhibit 2. Perform hypothesis testing and regression analysis on the data. Submit two Excel files with the following file names:
- Hypothesis_Testing_(Your Name)
- Regression_Analysis_(Your Name
Home 1Exhibit+1 Insert Page Layout Formulas Data Review View Q Search Sheet Cut Calibri (Body) * 11 Copy A- A Wrap Text "+ Share ~ Paste General Format B I U V Y Av _ AutoSum Merge & Center 7 % ) 00 .0 Fill AP . Conditional Format Cell Insert Delete x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Formatting as Table Format Styles Clear Sort & H14 fx Check for Updates B E G Rocinante 36 H Marengo 32 K L M N O P Q R Top T U V W Mileage Top X speed Z (km/Itr) Mileage AA Car No. speed (km/hr) Car No. (km/Itr) W N (km/hr) 21.2 151.9 15.04 211.3 21.79 147.6 15.41 207 21.87 145.6 15.43 206.2 au 22.71 136.1 15.92 22.52 213.4 39.7 15.2 204.2 21.41 46.1 15.22 208.7 22.71 39.6 10 8 14.6 200 21.71 143 11 9 14.41 210.9 19.95 36.4 12 10 14.79 208.5 20.65 146.6 10 11 14.81 214.2 22.86 139.9 11 12 15.61 215.8 21.12 136.6 12 13 15.76 215.8 22.8 148.5 16 14 13 14.97 215.2 20.89 143.4 17 15 14.71 22.49 218.7 134.2 15 16 15.55 208 20.94 40.5 16 19 17 15.19 212.2 20.37 137.8 17 18 15.36 219.7 22.72 135.1 18 19 15.93 216.4 20.54 38.8 19 20 14.54 205.8 21.14 132 20 14.76 209 28 33 34 35 36 37 38 39 Sheet1 + Select destination and press ENTER or choose Paste + 100%Exhibit+2 Q Search Sheet "+ Share ~ Home Insert Page Layout Formulas Data Review View _ AutoSum Cut Calibri (Body) * 11 A- A = Wrap Text General AP . Fill Copy Sort & Paste B I U V YA Merge & Center v % ) .00 Conditional Format Cell Insert Delete Format Clear Format Formatting as Table Styles Check for Updates x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. G2 fx M N O Q R U W X A D G H Sales Price Mileage Top speed Cars (in 1,000 units) (in lakh rupees) (Km/Itr) (Km/hr) Marengo 1 20.896 12.5 9.3 199.4 Marengo 2 31.048 36 9.7 235.2 4 Marengo 29.904 54.7 16.6 240.8 5 Marengo 4 28.792 42.7 11.7 232.5 6 Marengo 5 16.776 44.9 13.7 188.8 7 Marengo 6 18.928 35.5 9 .6 184.2 8 Marengo 7 22.776 51.3 13.7 207.7 9 Marengo 36.824 30.4 12.6 249.5 10 Marengo 22.216 38.4 16.2 175.8 11 Marengo 10 5.456 32.2 9.6 245.6 12 Marengo 11 28.576 59.4 11.3 223.3 13 Marengo 12 33.648 50.8 13.6 240 14 Marengo 13 33.44 57.5 13.5 250 15 Marengo 14 34.912 44.6 11.1 247. 16 Marengo 15 24.016 $4.6 14.1 192 17 Marengo 16 20.992 56.4 13.4 201.2 18 Marengo 17 21.696 41.4 12.8 193.3 19 Marengo 18 17.832 53.7 16 202 20 Marengo 19 25.624 44.8 12.7 208.9 21 Marengo 20 21.92 32.4 13.6 176.9 22 Marengo 21 24.792 40.9 11.6 218.2 23 Marengo 22 22.256 44.1 11.4 190 24 Marengo 23 15.48 46.6 16.3 176.8 25 Marengo 24 21.64 31.4 14.5 178.9 26 Marengo 25 23.264 54.7 14.3 192.3 27 Marengo 26 19.328 37.9 9.4 184.1 28 Marengo 27 27.216 52.9 15.3 240.3 29 Marengo 28 23.096 42.7 15 192.1 30 Marengo 29 17.824 54.9 13.5 199 31 Marengo 30 19.144 44 11.8 181.1 32 Marengo 31 21.6 42.2 9.3 181.2 33 34 35 36 37 38 39 D Rocinante Models Marengo Models + + 100% ReadyExhibit+2 Q Search Sheet Home Insert Data View "+ Share ~ Page Layout Formulas Review _ AutoSum Cut Calibri (Body) * 11 A- A = Wrap Text General AP . Fill Copy Merge & Center v % ) .00 Conditional Format Cell Insert Delete Format Sort & Paste Clear Format B I U V YA Formatting as Table Styles x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates N36 X V fx W C D F G H M N O Q R T U V Sales Price Mileage Top speed Cars (in 1,000 units) (in lakh rupees) (Km/Itr) (Km/hr) Rocinante 1 171.877 6.1 15.8 168.2 W N Rocinante 2 139.796 6.1 12.1 149.6 Rocinante 3 178.947 9.9 17 173.4 Rocinante 4 140.022 5.8 11.6 170.6 6 Rocinante 5 186.476 10 17.2 175 7 Rocinante 6 192.123 6.5 17.6 173.1 8 Rocinante 7 175.085 5.5 16 184.6 9 Rocinante 8 146.882 8.4 13 175.7 10 Rocinante 9 202.847 6.6 19.3 166.7 11 Rocinante 10 149.933 8.8 13.3 175.4 12 Rocinante 1: 171.579 9.5 15.8 150.9 13 Rocinante 12 201.512 9.2 19.2 140.5 14 Rocinante 13 142.604 8.1 11.7 150.2 15 Rocinante 14 135.158 5.4 11.2 146.2 16 Rocinante 15 107.322 5.6 7.8 151.2 17 Rocinante 1 199.699 6.3 19 143.2 18 Rocinante 17 202.875 5.8 19.7 178.9 19 Rocinante 18 204.406 7.7 19.5 168.2 20 Rocinante 19 107.331 7.2 7.5 164.7 21 Rocinante 20 190.345 8.4 18.1 182.7 22 Rocinante 2: 108.419 3.4 7.9 165.7 23 Rocinante 22 150.249 5.7 12.6 137 24 Rocinante 23 155.882 5.5 12.9 173.9 25 Rocinante 24 100.98 8.4 7.6 165.1 26 Rocinante 25 182.67 5.6 16./ 160.1 27 Rocinante 2 166.752 9.9 15.5 155.6 28 Rocinante 27 121.561 6.2 95 155.4 29 Rocinante 28 174.256 9.9 16.3 161.9 30 Rocinante 29 119.018 6.5 9.1 146.8 31 Rocinante 30 169.842 7.1 15.3 149.5 32 Rocinante 3 198.311 9.6 19.1 146.5 33 Rocinante 32 204.875 5 .8 19.4 178.9 34 Rocinante 33 119.561 6.2 94 175.4 35 Rocinante 34 203.87 5.9 19.4 175.9 36 Rocinante 35 118.561 6.1 9.4 165.4 37 38 39 40 Rocinante Models Marengo Models + + 100% Ready
