Calculating power of excel

Assignment Help Basic Computer Science

Reference no: EM131198880

Excel Instructions-

Part 1 - Organization

Within this set of instructions, you will be shown how to set up your spreadsheet with given raw data in an organized manner.

1. Start Microsoft Excel and select blank workbook.

2. Insert Raw Data into Workbook

Data > From Text > rawdata.txt > Import > Finish > OK

3. Rename Sheet by double clicking the sheet name in the bottom right of the spread sheet. Label as 'Raw Data'

Note: Never delete or modify raw data.

4. Separate Runs onto multiple sheets

Right click 'Raw Data' sheet tab > Move or Copy > Create a copy

Rename new sheet Run #1

Repeat this until you have separate sheets labeled

5. Cleaning up sheets

In Run #1, Highlight columns E-P (Runs #2-#4) and Right Click to Delete the data.

Repeat this in the other sheets so that only the Run # for the sheet name is showing.

6. Delete Time and Speed Columns for all runs. We will not need that data for this lab.

7. Final Adjustment to the Sheets

In sheet Run #1, either drag and move data down, or insert rows above Position and Force Columns.

Part 2 - Math Operations

Within these instructions, students are introduced to the math operations and calculating power of Excel. We pick up where we ended in the "organization" instructions. The following table is a filled with commonly used excel operations you will use throughout the semester. These are NOT the only commands that exist, there are THOUSANDS of commands that can be found through the help function or via an internet search.

Statistics	Trigonometry	Graphing	General
=Average()	=PI()	=SLOPE()	=SQRT()
=Median()	=SIN()	=MAX()	=SUM()
=STDEV.P()	=Radians()	=MIN()	=ABS()
=STDEV.S()	=Degrees()		=COUNT()
	=COS()
	=TAN()

Functions-

1. In Column D, next to the Force data, TYPE 'Stress' and 'Strain'

The stress being calculated is an axial stress. The formula for axial stress is Stress=Force/Area

The diameter of the circular cross section = 3.302 mm, find the area.

2. Calculate Stress

Select the cell directly under 'Stress' and TYPE the equation =Force/(diameter^2*PI()*0.25), where "Force" and "diameter" are their respective cells

As seen above in my formula bar, my force cell was C9, and my diameter cell was E4. You will notice also, in the formula bar above, there are $ in front of the E and 4. The $ isolates the cell/variable so that when you copy the cell, the formula is not copied but stays the same. For this equation, the diameter never changes so I put a $ in that cell.

3. Calculate Strain

The strain being calculated can be found from the following equation:

Ε = Δl/l₀

For this Lab, l₀ is equal to the Gauge Length and ?l refers to the position column.

Select the cell directly under 'Strain' and TYPE the equation = Position/Gauge Length

The gauge length is = 35 mm

4. Copy formulas down to the bottom of data set

Highlight the first box of stress and strain. Double click the small green square in the bottom right corner of the highlighted cells.

5. Repeat steps for the remaining 3 materials.

6. You should find by yourself the mechanical properties of the remaining materials

Part 3- Graphing

In this set of instructions, students are shown how to graph the data set from previous modules.

1. In Sheet Run #1, select INSERT > Scatter Plot

It should give an empty graph, if not, that is ok, you can adjust it later

Right Click the graph, and Select Data. If your graph is empty, then you will just need to ADD data. If Data already appears in the legend entries, REMOVE all to clear.

Click Add and you will get a box that looks like this...

The series name can be a referenced cell, or you can type the name, for this lets Reference a cell...

Click the select range button then Select the Cell that contains the name of the material, '2024-T3 Aluminum'

Click the select range button for Series X Values, These will be our STRAIN values. Highlight all the Strain Data.

Click the select range button fro Series Y Values, These will be our STRESS values.

Highlight all the Stress Data.

Concept Check: EXCEL

Refer to the instructions above on the proper way to organize, analyze, and graph your data.

1. Transfer the Raw Data into EXCEL

2. Organize the data

3. Perform math operations

4. Graph the data

Once you have completed ALL of the steps for ALL of the materials. Upload and submit your .xlsx file into this Assignment.

Attachment:- Assignment.rar

Reference no: EM131198880

Questions Cloud

What will happen to the ppf over time : Now suppose that a new technology is discovered that allows twice as many loaves of bread to be

Explain the natural history of this condition : Describe the host, the agent, and the environment which may interact within the same ecological system and have contributed to this condition.

What are the production costs of your economics class : Corporate funeral giants have replaced small family-run funeral homes in many areas, in large part because of the lower costs they achieve. What kind of economies of scale exist in the funeral business? Why doesn't someone build one colossal funer..

In how many hours will they be 4400 miles apart : Two planes leave JFK airport at the same time, one flying north at 500 mph and the other south at 600 mph. In how many hours will they be 4400 miles apart?

Calculating power of excel : Within these instructions, students are introduced to the math operations and calculating power of Excel. We pick up where we ended in the "organization" instructions

How this charge is an example of the price system at work : Given that revenues from these congestion charges are invested in the city's transport system, how will this affect the charge level holding all other variables constant?

What is the fair management fee for the hedge fund : What is the fair management fee for the hedge fund in the sense that it would make the investor indifferent between the two allocations (assume that the hedge fund charges a zero performance fee)?

What would a carpenter do in a similar situation : Suppose, as an economist, you are asked to analyze an issue unlike anything you have ever done before. Also, suppose you do not have a specific model for analyzing that issue. What should you do? Hint: What would a carpenter do in a similar situat..

Analyze integrated marketing communications : Develop strategies to assess performance and achieve marketing goals. Develop pricing strategies and distribution channels for products. Analyze integrated marketing communications and its relationship to advertising strategy.

Reviews

len1198880

9/8/2016 7:57:11 AM

When writing formulas, reference cells - as opposed to typing in numbers - as much as possible, Hovering over the small green box in the bottom left of the cell will create a black cross. If you click on this black cross, you can drag cells up, down, left or right to copy cells or formulas. Use Scatter Plot, NOT Line graph when plotting things with X and Y data. If you click on the graph, a green + will appear in the top right of the graph, these are your graphing options. If you Select the blue dots in the graph, the data you are using to plot will be shown in highlighted purple and blue column. Remember to step back and ask yourself, what SHOULD is look like. For example, can there be a strain on something that has had no for applied to it? Utilize the graphing options to adjust axis values and data markers to make your graph look as clear as possible.

9/8/2016 7:57:02 AM

I am aware that any attempt to or pass off other's work as my own, or assist other's with passing off work not their own, is a direct violation of the academic dishonesty policy and will result, at a minimum, in a zero on the assignment and institutional documentation. Be consistent- Use colors, borders, and font styles to keep order, Always keep words and numbers in DIFFERENT Cells. Utilize different sheets instead of having everything on one sheet or having multiple spreadsheets open and Never Delete Raw Data.

Write a Review

Required(*) Message

User Account

All Pages