Excel HW

Engr 102B Excel Homework (Individual)

Due to D2L dropbox on date shown on D2L

1. Predicting Wind Speed: As part of an experiment looking into how energy losses depend on wind speed, data was collected on air velocity at three distances from a portable fan. The data are shown in Table 1.

Table 1: Air Velocity at three Distances

From a Portable Fan

Distance (in)	Air Velocity (m/s)
8	2.0
8	1.9
8	2.0
8	2.2
8	2.1
16	1.3
16	1.2
16	1.1
16	1.2
16	1.2
32	0.5
32	0.4
32	0.5
32	0.5
32	0.5

The data was collected with a tape measure and a hand-held anemometer, and there are mixed unit systems in the data in Table 1.

Create an Excel worksheet containing:

a. The original data (from Table 1).

b. The distance data converted from inches to meters [2.54 cm/inch].

c. A plot of the distance (X axis) and air velocity (Y axis) values.

d. An exponential trendline through the data, with the trendline equation and R2 value shown on the graph.

2. Using a Pie Chart: A pie chart is useful in showing how a complete entity is divided into parts. The data in Table 2 show how the total cost of bringing a new technical product to market can be attributed to the various aspects of the development process.

Table 2: Costs Associated with New Product Development

Category	As Budgeted	Actual
Research	$1,200,000	$1,050,000
Patenting	$87,000	$89,000
Development	$1,600,000	$2,400,000
Legal	$32,000	$104,000
Marketing	$134,000	$85,000
Packaging	$48,000	$36,000
TOTAL:	$3,101,000	$3,764,000

Using Excel, create 2 pie charts, one for “As Budgeted” and one for “Actual.” Each pie chart needs to show the breakdown of each category.