Click on the Pie button in the Charts group and then select a chart from the drop down menu. Present your answers below the imported data table.Select the Insert tab in the toolbar at the top of the screen. Import the text file 'Weather.txt' into Excel and determine the following: (a) Average High Temperature for December (b) Average Low Temperature for December (c) Total Rain Fall for December (d) Standard Deviation of the High Temperature. Arc welding 11% Material handling 25% Paint & finish 14% Assembly 25% Spot welding 10% Other uses 15% (b) Then select Layout/Data Labels/Center to show the data. (a) Create a pie chart of the following data. (c) Recreate the path that the hurricane traveled, i.e., plot latitude (LAT) on horizontal axis and longitude (LON) on vertical axis. (b) Plot on the same graph Wind Speed in knots vs. Import the text file hurricane.txt' into Excel and (a) Insert a new column in the data table to show the wind speed in mph (note that wind speed given in the data file is in knots and to covert use 1 knot = 1.15 mph). Create a line graph of the function f(x) = 1 e* for x = 0 to 4 with increment 0.1 3. (c) Create a bar/column graph of R versus in degrees. (b) Use max() function to find the maximum value of R and print below the table. Convert degrees to radians by using the RADIANS() function since the SINO) and COSO functions in Excel use angles in radians. sin cos R= g (a) Create a table that computes R for a selected initial velocity V and angle 0. The horizontal range of a projectile fired into the air at angle degrees is given by the formula: 2.12. Do not forget to use appropriate formatting for adequate presentation and include titles and labels on graphs and tables. Transcribed image text: EGN 1007C-ENGINEERING CONCEPTS AND METHODS EXCEL ASSIGNMENT #2 Each problem should be worked in a separately labeled worksheet and all should be saved in one Excel file.

How to create pie chart in excel 1007