Exercise_Week12_Answer - MATH2871 DATA MANAGEMENT FOR...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
MATH2871 DATA MANAGEMENT FOR STATISTICAL ANALYSIS SEMESTER 2, 2010 Lab exercise Week 12 - Answers 1. Using Arrays for Repetitive Computations Monthly customer order data for the first half of the year is stored in the data set orion.orders_midyear. Orion Star Sales management is considering a 10-percent price decrease during the first three months of the upcoming year. Management wants to see how such a discount would affect this year’s sales. a. Create a data set, special_offer , including the 10-percent discount in months 1 through 3. Create a new variable , Mon , to access Month1 through Month3. Use a DO loop to adjust each customer’s monthly data to include the 10- percent discount ( Month1 through Month3 only). Create three new variables: - Total_Sales – total of current sales over the six months - Projected_Sales – the total of the adjusted sales over the six months (including the three discounted months) - Difference – the difference between Total_Sales and Projected_Sales Keep only the new variables: Total_Sales , Projected_Sales and Difference . b. Print the resulting data set and verify your results. Suppress the session start date, page number, and observation column. Add an appropriate title. Use the SUM statement to display a total for the Difference variable. Use the DOLLAR. Format for all variables.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Total Sales with 10% Discount in First Three Months Total_ Projected_ Sales Sales Difference $1,803.04 $1,733.93 $69.11 $9,186.41 $8,838.50 $347.91 $148.58 $140.76 $7.82 $601.62 $576.30 $25.32 $86.00 $83.06 $2.94
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/12/2011 for the course ASB 1001,2522, taught by Professor Nicole during the One '09 term at University of New South Wales.

Page1 / 5

Exercise_Week12_Answer - MATH2871 DATA MANAGEMENT FOR...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online