MIS 462 Summer2022 Summative Assignment

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


1000 points

Problems, Chapters 49 to 56-Charts


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 Summative05.xlsx, to the D2L Assignment Folder 'Summative05'.

Filtering-Chapter 49, Problem 6

Refer to the file makeupfilter.xlsx

Find all transactions in which Zaret or Betsy sold lipstick or foundation.

(50) 1. Make a screen shot of the first page of records, 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.

Data Consolidation-Chapter 50, Problem 2

Use these two files: JANcon.xlsx and FEBcon.xlsx

Create a consolidated worksheet that gives by region the largest first-quarter transaction for each product from the standpoint of revenue and units sold.

50) 2. Make a screen shot showing your consolidated worksheet 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.

Subtotals-Chapter 51, Problem 5

The data for this problem is in the file MakeupSubtotals.xlsx
Use the Subtotals command to compute the following:

(50) 3. Total lip gloss units sold for Hallagan


(50) 4. Grand total number of units sold


(50) 5. Salesperson with largest transaction (in terms of revenue) for eye liner


(50) 6. Salesperson Ashley lipstick dollar amount total

Charting Tricks-Chapter 52, Problem 1

Refer to the file Cakes.xlsx

Create a combination chart with a secondary axis to summarize monthly salespeople and revenues.

(50) 7. Make a screen shot of the chart, 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.

Linear Relationships-Chapter 53, Problem 1

The file DellData.xlsx contains monthly returns for the S&P (Standard and Poor's) stock index and Dell.
The beta of a stock is defined to be the slope of the least-squares line used to predict monthly return for a stock from monthly return for the market.

(50) 8. Estimate the beta of Dell.

Exponential Growth-Chapter 54, Problems 2,3,4,5

 The file ExponentialData.xlsx contains annual sales revenue for Staples, Wal-Mart, and Intel.
  For each company, fit an exponential trend curve to each company's sales data.

(50) 9. For which company does exponential growth best fit its revenue growth?


(50) 10. For which company does exponential growth have the worst fit to its revenue growth?


 (50) 11. For Intel from 2000 to 2001, estimate the annual percentage growth rate for revenues.

(50) 12. For Wal-Mart, use the trend curve to predict 2010 revenue.

Power Curve-Chapter 55, Problem 1

Use the fax machine data to model the relationship between cumulative fax machines produced and total production cost.

(50) 13. Make a screen shot of the power curve for fax machines, 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.

Correlations-Chapter 56, Problem 2

The data for the following problems is in file Ch52Data.xlsx
Worksheet Problem 2 contains daily sales volume (in dollars) of laser printers, printer cartridges, and school supplies.

(50) 14. Find and interpret the correlations between these quantities.

(100) 15. Combine your four screen shots from the previous exercises in order into one .pdf file named Summative05ScreenShots.pdf and upload this file to the D2L Dropbox folder 'Summative05 Screen Shots'