Hardcopy Submission

ENGR/MTH/PHYS-25
HomeWork 16 • Using MSExcel /

HARDCOPY SUBMISSION

This assignment is to be submitted in PAPER form. Black & White Printouts are acceptable, you do not need submit color printouts

If the Problem asks for a SPECIFIC Answer; e.g. the Area Under the Curve in P5, then CLEARY IDENTIFY the Answer by

Printing it in a BOLDfont

NOTE: The DATA contained in this document may be COPIED and PASTED into your excel spreadsheet; you do NOT have to ReType the Data.

See the Instructor if you have any questions about the CUT & PASTE operations

Problem-1

Figure 1Displays a scaled-down, Formatted Excel Table. Table I in this document contains the a set of text-data that is very similar to that shown in the well-formatted Table below. Copy & Paste the text-data into EXCEL and Format it as shown below. Some notes

Text is 14pt, Red, Some Text is BOLD
The Borders should all be Blue
color printout NOT required)

Figure 1 • Formatted Excel Table

Problem-2

Given the Data in Table II make a COLUMN chart with:

X-values →Year
Y-Values →“HomeRuns per 100-AtBats”
Calculated as: Y = HR/(AB/100)

The Chart Must be Properly Labeled and Formatted.

Problem-3

Given the Data in Table II make a LINE chart with a PRIMARY and SECONDARY Axes

X-values →Year
Y1-Values →AB/RBI (AtBats per RunsBattedIn)
Y2-Values →SLG (Slugging Percentage stated as a decimal)

The Chart Must be Properly Labeled and Formatted.

Problem-4

Given the Data in Table III make a XY-SCATTER chart with TWO Data series against a single Y-Axis

X Variable →DATE Format (Menu Tree: FORMAT →CELL →DATE)
Y1-1 Variable →MAXimum Temperature
Y1-2 Variable →MINimum Temperature

The Chart Must be Properly Labeled and Formatted.

Also use Excel’s BUILT-IN functions to calculate STATISTICS for the MAX & MINTemperature Data

AVERAGE
MEDIAN
MAXIMUM
MINIMUM
MODE
STANDARD DEVIATION

Problem-5

Given the function y = f(x) as shown in Figure 2. Use Excel to Find the AREA UNDER The Curve:

From X = 1.7 to X = 4.3
Use the TRAPEZOIDAL RULE as described in Lecture
Use 400 Vertical Strips
Beware of Fence-Post Errors
Report your answer to at Least FIVE significant Figures
In your HW-submission please show the FIRST-ten and LAST-ten rows of your 400+ row Spread sheet
Please also include the row/cell that shows the final answer

Problem-6

Table IV contains movement performance data for an XY-Translation Stage.

For more details on this topic see ENGR-25_Lec-31_XY-Translation-Stage_CaseStudy.ppton the ENGR-25 course WebPage

Use the data from Table IV to compute the statistically-best estimate of the stage VELOCITY

Hint: Make a Plot 

Table I • UCBerkeley Senior Year Course Planning for Mechanical Engr

Year 4 / Fall: Course Title / Course No. / Units / Spring: Course Title / Course No. / Units
Experimentation and Measurement / ME107A / 3 / Mechanical Engineering Laboratory / ME107B / 3
Heat Transfer / ME 109 / 3 / Computer-Aided Thermal Design / ME 145 / 3
Mechanical Engineering Design / ME 102B / 3 / Advanced Heat Transfer / ME151 / 3
Product Development / ME 110 / 3 / Applied Fluid Mechanics / ME 161 / 3
Introduction to MEMS / ME119 / 3 / Finite Element Analysis / ME C180 / 3
First Amendment and the Press / MASSCOM 104 / 3
Total Units / 18 / Total Units / 15

Table II • Selected BaseBall Statistics
For
Willie McCovey

Year / AB / HR / RBI / BB / SO / BA / SLG
1959 / 192 / 13 / 038 / 22 / 035 / .354 / .656
1960 / 260 / 13 / 051 / 45 / 053 / .238 / .469
1961 / 328 / 18 / 050 / 37 / 060 / .271 / .491
1962 / 229 / 20 / 054 / 29 / 035 / .293 / .590
1963 / 564 / 44 / 102 / 50 / 119 / .280 / .566
1964 / 364 / 18 / 054 / 61 / 073 / .220 / .412
1965 / 540 / 39 / 092 / 88 / 118 / .276 / .539
1966 / 502 / 36 / 096 / 76 / 100 / .295 / .586
1967 / 456 / 31 / 091 / 71 / 110 / .276 / .535
1968 / 523 / 36 / 105 / 72 / 071 / .293 / .545
1969 / 491 / 45 / 126 / 21 / 066 / .320 / .656
1970 / 495 / 39 / 126 / 37 / 075 / .289 / .612
1971 / 329 / 18 / 070 / 64 / 057 / .277 / .480
1972 / 263 / 14 / 035 / 38 / 045 / .213 / .403
1973 / 383 / 29 / 075 / 105 / 078 / .266 / .546
1974 / 344 / 22 / 063 / 96 / 076 / .253 / .506
1975 / 413 / 23 / 068 / 57 / 080 / .252 / .460
1976 / 226 / 7 / 036 / 24 / 043 / .204 / .336
1977 / 478 / 28 / 086 / 67 / 106 / .280 / .500
1978 / 351 / 12 / 064 / 36 / 057 / .228 / .396
1979 / 353 / 15 / 057 / 36 / 070 / .249 / .402
1980 / 113 / 1 / 016 / 13 / 023 / .204 / .301

Big Mac Biographical Info

Willie Lee McCovey (Stretch, Mac, or Big Mac)
Bats Left, Throws Left
Height 6' 4", Weight 210 lb.
Debut July 30, 1959
Final Game July 6, 1980
Born January 10, 1938 in Mobile, AL
Inducted into the Hall of Fame in 1986 (1st year of Eligibility)
346 votes on 425 ballots = 81.41%.

Table III • Jul&Aug 2011 Temperature Data For Oakland Airport

Date
(dd-mm-yy) / MAX Temp
(°F) / MIN Temp
(°F)
1-Jul-11 / 81 / 53
2-Jul-11 / 73 / 55
3-Jul-11 / 86 / 55
4-Jul-11 / 74 / 54
5-Jul-11 / 84 / 53
6-Jul-11 / 75 / 52
7-Jul-11 / 70 / 52
8-Jul-11 / 73 / 52
9-Jul-11 / 66 / 52
10-Jul-11 / 68 / 55
11-Jul-11 / 62 / 52
12-Jul-11 / 64 / 53
13-Jul-11 / 65 / 54
14-Jul-11 / 62 / 54
15-Jul-11 / 61 / 54
16-Jul-11 / 66 / 54
17-Jul-11 / 70 / 55
18-Jul-11 / 73 / 54
19-Jul-11 / 72 / 55
20-Jul-11 / 82 / 54
21-Jul-11 / 72 / 52
22-Jul-11 / 75 / 53
23-Jul-11 / 69 / 55
24-Jul-11 / 70 / 56
25-Jul-11 / 66 / 52
26-Jul-11 / 69 / 52
27-Jul-11 / 73 / 51
28-Jul-11 / 71 / 52
29-Jul-11 / 68 / 54
30-Jul-11 / 71 / 59
31-Jul-11 / 71 / 59
1-Aug-11 / 72 / 59
2-Aug-11 / 72 / 57
3-Aug-11 / 70 / 56
4-Aug-11 / 64 / 57
5-Aug-11 / 70 / 55
6-Aug-11 / 69 / 55
7-Aug-11 / 62 / 54
8-Aug-11 / 62 / 51
9-Aug-11 / 66 / 49
10-Aug-11 / 70 / 49
11-Aug-11 / 67 / 53
12-Aug-11 / 66 / 51
13-Aug-11 / 68 / 50
14-Aug-11 / 70 / 50
15-Aug-11 / 69 / 50
16-Aug-11 / 67 / 51
17-Aug-11 / 61 / 49
18-Aug-11 / 63 / 49
19-Aug-11 / 64 / 54
20-Aug-11 / 67 / 56
21-Aug-11 / 68 / 55
22-Aug-11 / 71 / 52
23-Aug-11 / 87 / 51
24-Aug-11 / 75 / 58
25-Aug-11 / 70 / 56
26-Aug-11 / 72 / 55
27-Aug-11 / 71 / 54
28-Aug-11 / 71 / 54
29-Aug-11 / 69 / 53
30-Aug-11 / 71 / 57
31-Aug-11 / 73 / 55

Data Source →

Figure 2 • Function to Integrate using the Trapezoidal Rule for Problem-5

Table IV • XY-Stage Move-Performance Data

Travel Distance, d / Travel-Time, t
(mm) / (mS)
7.841 / 38.00
7.841 / 44.400
14.139 / 125.600
14.139 / 132.800
16.167 / 112.800
16.167 / 120.800
16.167 / 128.800
16.167 / 138.400
31.363 / 190.000
31.363 / 206.000
56.555 / 318.000
56.555 / 334.000
64.669 / 244.000
64.669 / 320.000
64.669 / 320.000
64.669 / 324.000
169.664 / 824.000
169.664 / 832.000
172.498 / 856.000
172.498 / 856.000
180.888 / 768.000
180.888 / 776.000
180.888 / 816.000
180.888 / 824.000
180.888 / 832.000
180.888 / 840.000

Print Date/Time = 31-Oct-18/04:36