Template_of_Week2Lab_Excel

# Template_of_Week2Lab_Excel - Welcome to Our First Lab for...

This preview shows pages 1–8. Sign up to view the full content.

Welcome to Our First Lab for MATH 221!!! These labs are designed to show you how to use Excel to help with statistical analysis. If you are familia Excel, that is great! If not, don't worry, we'll show you everything you need to know to successfully work t the labs. To start, this file contains several worksheets. The names "Accounts, Cereal, Milk Production, appear at the bottom. Each of these worksheets has an assignment for you to complete. Simply follow t instructions in yellow to complete each worksheet's assignment. Be sure to view the Tutorials that are associated with each lab. These Tutorials are interactive presentat someone actually using Excel to work through examples similar to the labs you are asked to do. What You Should Turn In: Each lab should consist of ONE file that you turn in. Use Excel to perform the calculations or generate th but then COPY-and-PASTE your work from Excel into Word . To Copy-and-Paste cells (or graphs) from Excel to Word: 1. Highlight the cells (or select the graph) in Excel you want to copy-and-paste 2. From the Excel menu, select Edit, then Copy 3. Go into Word and place the cursor where you want to paste your cells. 4. From the Word menu, select Edit, then Paste 5. Your work should have copied itself into Word. (Note: Can also right-click to select copy and/or paste.) Save your ONE Word file using the filename format "lastname_firstinitial_week#lab". For example, if Albert Einstein and you are submitting your Week 6 lab, the filename should be "einstein_a_week6lab".

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
ar with through , " etc. the tions of he graph, f you are
AA 1 2 2 AB 2 26 8 AC 3 36 14 AD 4 16 16 AE 5 73 20 AF 6 20 25 AG 7 39 26 AH 8 48 33 AI 9 36 36 AJ 10 72 36 AK 11 39 39 AL 12 47 39 AM 13 56 42 AN 14 8 47 AO 15 57 48 AP 16 42 56 AQ 17 33 57 AR 18 25 58 AS 19 58 72 AT 20 14 73 AU 21 AV 22 AW 23 AX 24 AY 25 AZ 26 BA 27 BB 28 BC 29 BD 30 BE 31 BF 32 BG 33 BH 34 BI 35 BJ 36 BK 37 BL 38 BM 39 BN 40 BO 41 BP 42 BQ 43 BR 44 BS 45 BT 46 BU 47 BV 48 Account Name Random Sample Ordered Sample

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
BW 49 BX 50 BY 51 BZ 52 CA 53 CB 54 CC 55 CD 56 CE 57 CF 58 CG 59 CH 60 CI 61 CJ 62 CK 63 CL 64 CM 65 CN 66 CO 67 CP 68 CQ 69 CR 70 CS 71 CT 72 CU 73 CV 74
Instructions: Randomly select 20 of the accounts at left. (You may want to add a numerical column beside the account names!) Use the column at right (Random Sample) to list the raw account numbers. Then, order the column to create an ordered list. Question: Why is it important for the auditor to randomly select files for auditing? Why not just audit all of the files? Be sure to COPY-and-PASTE your Ordered Sample column into your Word document.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Fiber Type Calories Fiber Type High Fiber 38 2.00 0 100 High Fiber High Fiber 34 2.00 0 120 Medium Fiber High Fiber 21 1.50 12 110 Low Fiber High Fiber 23 1.50 9 110 Total High Fiber 23 1.50 8 110 High Fiber 51 2.00 17 180 High Fiber 28 2.00 0 220 High Fiber

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 23

Template_of_Week2Lab_Excel - Welcome to Our First Lab for...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online