Question

3. Using Excel to solve the problems below If there is cube which has length I 9m and width w-5m the height of the cube could be represented as h, the total surface area could be calculated as: S-2 (w l +w h+h l) If h increases from 1m to 15m, each time h increases 1m, build a table in Excel to include 2 columns, one is for h and the other is the calculated total surface area S. Plot the XY-scatter chart for the table. Use MATLAB to solve the following problems. 4. If you have 11 people, how many different committees of two people each can you create if the choosing order does not matter? a) b) How many different basketball teams of 5 players can you form from a class of 15 students? Combinations-order does not matter.) c) Since each player on a basketball team is assigned a particular role, order does matter. Recalculate the possible number of different basketball teams that can be formed when order is taken into account. Formulas below may be useful for you to solve the problem.

Answer 1

3)

Koteswara Rao Unnam -0 × 12345678911235 Chart Tools Book1 - Excel 日勺. FormatTell me what you want to do Design Nitro Pro 10 Help View Review Data Formulas Page Layout Calibri (Body) 10AA B l u. |田· 2.Д. AutoSumA Insert 曹Wrap Text ーーーウ· Cut Sort & Find & Filter Select . | $. % , 엶48 | conditional Format as Cel Formatting Table" Styles Insert Delete Fonmat Clear Copy ΞΞ 트 트自Merge & Center Editing Fonmat Painter Chart 1 174 400 10 314 370 Height, h 17 510 21 + 100% Sheet1! Ready