Lab 1 | him325 | DeVry University

MATH325 Lab 1

Excel Orientation and Set-Up

Data Analysis with Comprehensive Statistics Software


Task: Set-up to get hands-on practice

Classes that use Microsoft Excel are designed to provide hands-on practice as a key part of the learning experience.

Follow the instructions below access Microsoft Excel.

1. For PC and Mac:

· Login to the student portal (http://my.devry.edu) from a web browser on your PC or Mac.

· Click the envelope found at the top of the page near your name to access your student email account.

· You will automatically be redirected to your student email account using Outlook.

· To access your subscription, click on the Office 365 button in the upper left-hand corner.

· To begin the installation of Office, click the Install Office button and follow the on-screen instructions.

2. For iOS and Android:

· Download from your app store:

·
Windows
 (Links to an external site.)

·
iPhone & iPad
 (Links to an external site.)

·
Android
 (Links to an external site.)

· Sign in using your school credentials for full editing capability (Please note that you will be prompted to enter your school email address and then sign-in using your normal credentials).

Contact the Help Desk immediately with any questions or issues that arise.

Once you are able to access the software go to Files area in your course shell, in the Health Care Statistics & Research folder, to download the HealthCareData.xlsx file needed for the labs. You are now ready to open Excel and work with the data sets.


Introductory Excel Overview

Open Excel and review various menus and reports through the tutorial.

Launch the following
videos from Microsoft to walk you through Excel:

https://support.microsoft.com/en-us/office/video-what-is-excel-842fb550-07cb-42d1-9a9f-c55789efed57?ui=en-us&rs=en-us&ad=us

Follow along these short videos (~1 minute) and try the steps suggested in the videos:

· What is Excel?

· Create a workbook

· Insert or delete a worksheet

· Move or copy worksheets

· Fill data automatically

· Create a drop-down list

Continue on to Rows & Columns:

In these short videos, follow along and practice how to:

· Insert or delete rows or columns

· Change the column width and row height

· Freeze columns or rows

· Hide or unhide columns

· Split data into different columns

· Combine data

For additional instruction, continue to work through the

Cells, Formatting, and Formulas and Functions
video sets.

Once you have a basic understanding of introductory Excel, let’s look at how we can use excel for statistics.


Load the Analysis ToolPak into Excel

Check out the Data tab on the toolbar:

If you do not see Analysis TookPak, click on File Options:

This opens up the following window:

3.

2.

1.

Click on:

1. Add-ins, which is located towards the bottom of the left-hand column; then,

2. Analysis ToolPak;

3. Under Manage: Excell Add-ins, click Go.

In the Add-ins menu, select Analysis ToolPak, and click OK.

You should now have an Analysis area under your Data tab in Excel:

The Analysis ToolPak can be used to work through complex data analysis. Click on the following link for more information:
https://support.microsoft.com/en-us/office/use-the-analysis-toolpak-to-perform-complex-data-analysis-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6

Read through the ANOVA and Regression areas found in the link above:


Deliverables

Once you have watched the introductory Excel videos, and read over the ANOVA and Regression areas (found in the links above),

submit a 1 page summary of navigational challenges and issues you had in set-up, as well as, what you liked or what excited you about learning Microsoft Excel
.

This summary should be in submitted into Week1: Lab.

Page 7

image1.PNG

image2.png

image3.png

image4.PNG

image5.PNG

image6.PNG

image7.png

image8.PNG

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more