MIS 462 Summer2022 Summative Assignment

Email Address: First Name: Last Name:
Semester: Class: StarID:
Section: Assignment:  
 


1100 points

Problems, Chapters 38 to 43, 47 and 48


Do all of these problems in a single Excel Workbook.
Solve each problem on a separate Worksheet.
Your Excel File must be setup like you did in Formative01 with appropriate Worksheet tab names.


(200) When done, upload your file, named Summative04.xlsx, to the D2L Assignment Folder 'Summative04'.

Importing Text-Chapter 38 Problem 2

use the file Lineupsch33.docx
This file is located in the StudentDataFiles folders.

1. (50) Once you have imported the doc file into Excel (hint: refer to the book for details), column H lists time played in minutes with a prefix of 'm'.
Create a formula for column K that strips out the 'm' suffix and converts the text to a number.

Internet Import-Chapter 39

The URL
https://www.bea.gov
contains a wealth of data about U.S. economics, such as the gross domestic product (GDP) in the United States.
You can import and work with this data in Excel.
Use this file concerning US truck production.

(50) 2. Make a screen shot of your imported data, save it in a convenient location as you will combine it into one pdf file when you complete this assignment.
Refer to Assignment Formative00, Exercise 7 for details.

(50) 3. Make a brief list of three (3) things you can learn from the GDP data. Hint: graph the GDP data on a per quarter basis for all quarters/years!

Validating Data-Chapter 40 Problem 3

4. (50) The List option in the group of data validation settings enables you to generate an error message if a value that is not included in a list is entered in the cell range you're validating.
Suppose you are entering employee first names in the cell range A1:A10.
The only employees of the company are Jen, Greg, Vivian, Jon, and John.
Use the List option to ensure that no one misspells a first name.
This problem is done by using a blank worksheet, you supply the necessary data.

(50) 5. Make a screen shot of the Data Validation Dialog Box, save it in a convenient location as you will combine it into one pdf file when you complete this assignment.
Refer to Assignment Formative00, Exercise 7 for details.

Histograms-Chapter 41 Problem 1

6. (50) Use the data in Stock.xlsx to construct histograms for monthly returns on GE and Intel (INTC).
(50) 7. Make a screen shot of the GE histogram, save it in a convenient location as you will combine it into one pdf file when you complete this assignment.
Refer to Assignment Formative00, Exercise 7 for details.

Descriptive Statistics-Chapter 42 Problem 1

8. (50) Use the data in the file Stock.xlsx to generate Descriptive Statistics for Intel and GE stock.

(50) 9. Make a screen shot of the Intel results table, save it in a convenient location as you will combine it into one pdf file when you complete this assignment.
Refer to Assignment Formative00, Exercise 7 for details.

10. (50) Use Descriptive Statistics to calculate the mean of the GE stock price:

Pivot Tables-Chapter 43 Problem 4

You will find the data in the file Hospital.xlsx

You have been assigned to evaluate the quality of care given to heart attack patients at Emergency Room (ER) and Chicago Hope (CH).
For the last month you are given the data for:

Using this data determine which hospital did a better job of caring for heart attack patients.
Use all the data.

(50) 11. Hospital doing better job:

(50) 12. Your explanation of why this hospital is doing a better job.

Sparklines-Chapter 47 Problem 2

The data Dow.xlsx contains the values of the Dow Jones Index for January 2–August 10, 2010.
Create a line sparkline to show the ups and downs of the market.

(50) 13. Make a screen shot of the Sparklines cell, save it in a convenient location as you will combine it into one pdf file when you complete this assignment.
Refer to Assignment Formative00, Exercise 7 for details.

Database Functions-Chapter 48 Problem 5 (partial)

Use the data in the file makeupdb.xlsx to determine the following:

(50) 14. Total unit sales in the Midwest

(50) 15. Total units that Heather sold in the East:

(50) 16. Total units that Heather sold or that were sold in the East:

(100) 17. Combine your five screen shots from the previous exercises in order into one .pdf file named Summative04ScreenShots.pdf and upload this file to the D2L Dropbox folder 'Summative04 Screen Shots'