All our Essay orders are Original, and are written from scratch. Try us today at 30% off

biokogy pre lab excell homeworks

Want answers to the assignment Below?

Text or Whatsapp Olivia at +1 (307) 209-4351


 

Learning Objectives At the end of this workbook students will be able to: Enter values into cells and format them Create a table appropriate for graphing with rows of cases and columns of variables Sort data Instructions 1) SAVE A COPY – Download this file onto a flashdrive or the desktop (which you will then send to yourse –> Top left corner “office button” –> Save As —> Name file “Excel Template” and save Keep this file for reference now and for other analyses/classes. 2) Reopen this file and work through each tab at the bottom in sequence. Be sure to complete the acti Save it and send it to yourself – you’ll be entering data, doing analysis and creating a graph as part of th Be sure to scroll down and up the page (see scroll bar far right) to make sure that you start at the TOP of each pa Workbook – an Excel document like this Worksheet – each Workbook can have multiple worksheets – see the tabs at the bottom? Each one is a different wo s and creating a graph as part of the exercise, then doing the same for your own lab. Review this sheet to learn the basics of Excel. Start by viewing one or both of these videos by GCF (Goodwill Community Foundation) https://www.youtube.com/watch?v=J4zq3R8b5dQ http://www.youtube.com/watch?v=jQGo3dPPQoc An 11:26 minute video that assumes that you have no knowledge A 4:20 video that focuses on how to work with cells, and assumes Below is an image of Excel with important components from Excel 2010, which will be similar to 2007. Review carefully to familiarize yourself with important features. SOURCE: http://www.saylor.org/site/textbooks/H (Creative Commons License) Excel 2013 is very similar. Click here for a tour of the 2013 spreadsheet. If you are new to Excel you will want to v http://www.gcflearnfree.org/office2013/excel2013/4 mes that you have no knowledge of Excel; it uses the 2013 version. It is a good refresher, even if you are familiar with Excel. to work with cells, and assumes you know some basics. It uses Excel 2010, however many screenshots shown apply to Excel 2013. p://www.saylor.org/site/textbooks/How%20to%20Use%20Microsoft%20Excel.pdf mmons License) are familiar with Excel. ts shown apply to Excel 2013. Excel is an important tool for managing and analyzing data Excel is regularly used for scientific studies to: Create tables and spreadsheets Explore and organize data Do descriptive and comparative statistics Represent data and summaries or statistics graphically The simple study we are using as an example is a study of the heights of female and male students in an Intro Eco Hypothesis: Null hypothesis: Prediction: On average men are taller than women There is no difference in height between men and women The average height of male students will be (statistically) greater than the average h Application You will use this data set throughout your tutorial, however the goal is for you to apply this knowledge to your own create a table of data, organize it, calculate statistics, and present your data and results graphically. You can use this workbook for your own data, but use the tutorial to make sure you understand what you’re doin Parts of a spreadsheet (table) Read through the yellow boxes so that you understand how data can be organized ROW – uses numbers, horizontal, represents CASES COLUMN vertical, uses letters, represents VARIABLES The data shown here is of the heights of female and male students. In th Each “case” is a student whose height has been measured. The actual he NOTE: Always provide a title and include units Height in cm Male Female NOTICE – we will be comparing the heights of females to 187,0 151,8 males, the order of the data within each column does 172,0 147,3 NOT matter. 169,0 157,5 176,0 179,0 205,0 154,0 184,0 156,0 183,0 164,0 172,0 157,0 170,0 165,0 183,0 163,0 NOTE: while there are advantages to having the same number in 186,0 156,0 each category of independent variable (here, female and male), it is 166,0 not necessary emale and male students. In this case the variables are “female” and “male”. been measured. The actual heights are the data. e heights of females to n each column does to having the same number in iable (here, female and male), it is Formatting cells Altering the appearance, position, color etc. of a cell can help make information easier to read and understand. 1. Watch this video for simple instructions on basic formatting of cell contents http://www.youtube.com/watch?v=AH7cT96frWs Refer back to this video to learn to cut and paste http://www.youtube.com/watch?v=jQGo3dPPQoc 2. Answer these questions: Where is the undo button? In the table below, do Male and Female represent columns or rows? In the table below, do the heights represent columns or rows? What is the hypothesis being tested? 3. Copy, paste, then format the table. Look at the table to the left and compare it to that on the right. The table on the right is clearer and the numbers make more sense. Learning how to format can help you more easily manipulate cells and present data. Table Without formatting Height in cm Male Female 187,0000 151,8000 172,0000 147,3000 169,0000 157,5000 176,0000 179,0000 205,0000 154,0000 184,0000 156,0000 183,0000 164,0000 172,0000 157,0000 170,0000 165,0000 183,0000 163,0000 186,0000 156,0000 166,0000 With formatting NOW YOU DO IT! Use the directions on this sheet Create a formatted table here Male 187.0 172.0 169.0 176.0 205.0 184.0 183.0 172.0 170.0 183.0 186.0 Female 151.8 147.3 157.5 179.0 154.0 156.0 164.0 157.0 165.0 163.0 156.0 166.0 DIRECTIONS First copy the cells Without formatting and paste them starting in cell G21 (column G, row 31) Now format the cells so that they look like those in the table With formatting. You will need to: Change the number of decimals shown to one place (e.g. 187.0 vs. 187.0000) Center cells with data Bold the headings Put a line under headings Shade headings How do you do all this? The videos will show you how! You can also go YouTube to ask specific questions about Excel 1 (column G, row 31) Sorting Data Sometimes you would like to know the highest and lowest values of the data, and the total range. There’s a formu Depending on the version of Excel you have, this can be accomplished in different ways. The most important thing to consider is whether or not you need to have all the data in a row stay in that row – in th if that is the case you need to make sure that everything is sorted together. The easiest way to do this is to select all In our example male/female heights don’t need to be sorted together, so we will sort each variable separately. Height in cm Male Female 187,0 151,8 172,0 147,3 169,0 157,5 176,0 179,0 205,0 154,0 184,0 156,0 183,0 164,0 172,0 157,0 170,0 165,0 183,0 163,0 186,0 156,0 166,0 Put Your Table Here First Find the shortest, tallest, and range of heights for both females an 1. Copy and paste the table starting in cell 10D (Row 10, Column D) 2. Select the Female column (Female and all values) 3. Click on the Data tab on the toolbar 4. Find Sort, and click on the AZ arrow option. If you get a dialogue box li just click “continue…” 5. Check your results. Is the smallest number at top and the largest on th 6. Now do the same for Male data 7. Answer the questions below and check them for accuracy 8. Check your answers Second Answer the following questions: What is the height of the shortest woman? What is the height of the tallest woman? What is the height of the shortest man? What is the height of the tallest man? The range is the simplest expression of the spread of data – it is the diffe between the minimum value (smallest) and the maximum value (largest) What is the range of heights for women? What is the range of heights for men? in a row stay in that row – in this case that would mean male and female heights staying together.
The post biokogy pre lab excell homeworks first appeared on Assignment writing service.

Testimonials

Best

They look cool and trustworthy enough to me. I gather they made discounts as their prices are quite affordable if...

No Complaints So far Guys

Yeah …I really like all the discounts that they offer, the prices are very flexible. Plus they have different promotions...

Best Service

The book review I asked for is so amazing! Endless thanks to your team for completing my review and for...

Mh! not bad…

The worst part ever was to find my deadline postponed for 1 hour ! They couldn`t finish the essay within...

Comes through every time

I have used this website for many times, and each time they found perfect writers for me and they produce...

Great Job

Great job! Those were you, guys, who made my coursework perfect in time according to all my requirements. I will...

CLICK HERE  To order your paper

About Scholarfront Essay writing service

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for upto 20% off in their first Order. Our payment method is safe and secure.

 CLICK HERE to Order Your Assignment

 

ORDER WITH 15% DISCOUNT

Let your paper be done by an expert

Custom Essay Writing Service

Our custom essay writing service has already gained a positive reputation in this business field. Understandably so, all custom papers produced by our academic writers are individually crafted from scratch and written according to all your instructions and requirements. We offer Havard, APA, MLA, or Chicago style papers in more than 70 disciplines. With our writing service, you can get quality custom essays, as well as a dissertation, a research paper, or term papers for an affordable price. Any paper will be written on time for a cheap price.

Professional Essay writing service

When professional help in completing any kind of homework is all you need, scholarfront.com is the right place to get it. We guarantee you help in all kinds of academia, including essay, coursework, research, or term paper help etc., it is no problem for us. With our cheap essay writing service, you can be sure to get credible academic aid for a reasonable price, as the name of our website suggests. For years, we have been providing online custom writing assistance to students from countries all over the world, including the United States, Canada, the United Kingdom, Australia, Italy, New Zealand, China, and Japan.