Good Morning,

This is the 3rd homework assignment I am requesting of you as you have did excellent on the two prior which I greatly appreciate. This is a new course that is starting today and I am attaching the "General Homework" which shows what is expected on assignments and then the Ch 1 Percent Graph Hmwk is the main assignment. The last question on the assignment refers to an excel file which is also attached and called real estate 85 data su17. For the name purposes on the assignment, my name is Amber Henson. I will also submit a 2nd assignment once this one is received back that is a simple quiz. Please confirm that you are comfortable with this work as this course is "Quantitative Methods" for Business Decisions.

Thank You! I look forward to having you help me on several more assignments this semester!

BADM 3963 Ch 1 Introduction to Mgmt. Sci., Percentages, Excel, Graphs Homework Summer 2017 Excel is mainly being used as a calculator for this work. Read the Percentage, Graph notes, watch Excel basics, Graphs podcasts. Read the General Homework instructions All work will be done in one Excel file Make sure your name is at the top of every EXCEL worksheet (type in Cell A1) Complete sentences and proper grammar must be used when reporting all of the answers. Put work and answers for problems 1-5 on a single worksheet - clearly separated, labelled, easy to find and follow. For problems 1 through 5, enter the numbers given in the problem in a spreadsheet, labeled appropriately and then make EXCEL do all of the calculations. Use cell addresses in your calculations as much as possible (see example below). Type answers to questions 6-10 on a second worksheet - clearly separated, labelled, easy to find and follow Copy the Real estate data, do calculations and type answers on a third worksheet in the same Excel file. Label each worksheet tab . Submit the Excel file in Blackboard Assignments. Due 6/ 12/17, 9pm. Example: #1. A business math student answered 60 questions correctly on a 75-question test. What percent of the questions were answered correctly? Excel worksheet 1 2 3 4 5 6 A Anne Davey Percent problems #1 Number of test questions Number of questions correct B Percent of questions correct 80% Answer The student answered 80% of the questions correctly obtained in B6 by entering =B4/B3*100 . 75 60 Note: Results 1. A student answered 86 problems on a test correctly and received a grade 98%. How many problems were on the test, if all the problems were worth the same number of points? (Round to the nearest whole number) 2. A math book at the Victor Valley College bookstore originally cost $84 to purchase. If they sell it for $126, what is the markup rate (markup on cost)? 3. Peter Pringle has accepted a summer job selling magazine subscriptions door-to-door. Peter is paid strictly on commission and receives a 2% commission on all sales that he makes. Peter is hoping to make enough money over the summer to pay for a new Xbox game system which costs $250. If each subscription is sold for $35, how many subscriptions will Peter have to sell in order to make enough to buy the game system? 4. Lowes in Rancho Cucamonga is having a one-day 20% off sale. The sale price be for an exterior door is $288. What was the regular price? 5. An employee's salary increased by $4,500 which represents a 15% raise. What is the employee's new salary? 6. Match the following terms with the correct descriptions/definitions Terms A. Prescriptive model B. Descriptive model C. Predictive model Descriptions/Definitions 1. May be used to forecast future results. 2. A numerical constant in a mathematical model 3. Used to determine how results would change if model inputs are changed. 4. Used to find the \"best\" solution under relatively static, well-defined conditions 5. A changeable quantity in a model which may be controlled by the decision maker. 6. Helps management to understand the current condition of their operations. D. Parameter E. Variable F. Sensitivity Analysis . 7. Interpret the following histogram 8. Sales results for Simple Simon Pies in the last two quarters of 2016 have been recorded and the bar chart below created. Use the bar chart to answer the questions. a. Which month has the highest sales? b. Estimate the total sales for the third quarter. c. Find the ratio of December to July sales. 9. Refer to the following breakdown of responses to a survey of "Are you concerned about being tracked while connected to the Internet"? a. What is the class with the lowest frequency? b. If 225 respondents answered Very Concerned, approximately how many people took part in the survey? survey? 10. Interpret the following xy graph (scatterplot). Hours worked vs GPA 4 3.5 3 2.5 GPA 2 1.5 1 0.5 0 0 5 10 15 20 Hours worked 25 30 35 11. Real Estate Data Analysis The Excel file labeled REAL ESTATE contains data on 85 homes sold by a large real estate company in the past three years. You have been asked to provide some analysis of the data for the company's management team Copy the data into a new worksheet in your Excel file to complete the activities described below. Use Excel functions to arrange and analyze the data as required to produce the results described below. Make Excel do all of the work. I must be able to see your functions and formulas in the EXCEL file by toggling to show formulas. Report the results in your Excel file close to the analysis that was used. Make sure the work and answers are well labelled and organized so the reader can follow it easily. Use complete sentences to report answers where appropriate. 1. Count of the number of houses that have a garage and the number that do not have a garage o Use the Excel COUNTIF function (watch the podcast and if you need additional help with this or any other function use the Excel Help) 2. Create a pie chart to display the results from #1. 3. Count of the number of houses in each of the five locations o Use COUNTIF function (watch the podcast and if you need additional help with this or any other function use the Excel Help) 4. Create a bar chart to display the results from #3 5. Create the appropriate graph to show the relationship between Price and Size (copy just the Price and Size data into a new worksheet) o Regression review and preview ---Think about which variable, Price or Size, is likely to be the dependent variable (the one you want to predict) and which is likely to be the independent variable (the one we use to predict the other). We want the dependent variable to be on the vertical (y) axis and the independent variable to be on the horizontal (x) axis. Excel will automatically put the first column of data on the horizontal axis of a scatterplot and the second column on the vertical axis. Organize your data accordingly to make the graph. 6. Calculate the average size of house sold and the average price (use Excel AVERAGE function). 7. Use the results from #6 to calculate the average price per square foot. General Homework Instructions BADM 3963 Read and follow the instructions on each homework assignment. They may vary from assignment to assignment. Your name must be the first thing typed in every Word document and every Excel worksheet. Work submitted without your name will not be graded. Consider your work to be professional presentations. They should be well-organized and a positive reflection of your ability to communicate. Make sure that your work is easy to read and follow o In Excel use a separate worksheet for each problem - with labeled tabs. o In Word use white space, headings, indentations to make the report more readable When reporting answers: write complete sentences, use correct grammar and spell check your work. If you are asked to report answers: \"Reported\" means answers should tell a complete story. Here is an example: o Inadequate, unacceptable answer: 5 o Acceptable answer: The NPV for project D is $5 million. When a Word document is used to report results from Excel, any significant tables or graphs should be copied into the Word document from Excel. o The entire spreadsheet should NOT be copied into Word. o The Excel file will also be submitted. Learn to re-size Excel tables and graphs so the work fits on a single page in Word. o At this stage in your career, you are responsible for learning how to use the software appropriately. When submitting two files (one Word and one Excel) you must attach both before you hit the Submit button in Blackboard. o Never submit more than two files - one Word and one Excel would be the max. House 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 Price Bedrooms Size Pool 263.1 4 2300 192.4 4 2100 242.1 3 2300 213.6 2 2200 149.9 2 2100 245.4 2 2100 327.2 6 2500 271.8 2 2100 225.2 3 2300 266.6 4 2400 292.4 4 2100 208.5 2 1700 270.8 6 2500 246.1 4 2100 194.4 2 2300 281.3 3 2100 182.7 4 2200 207.5 5 2300 198.9 3 2200 209.3 6 1900 252.3 4 2600 192.9 4 1900 209.3 5 2100 345.3 8 2600 326.3 6 2100 173.1 2 2200 188.4 2 1900 257.2 2 2100 235.5 3 2200 180.4 2 2000 236.5 2 1700 208.5 2 2000 247.7 5 2400 166.2 3 2000 177.1 2 1900 182.7 4 2000 217.9 4 2300 312.1 6 2600 199.8 3 2100 273.2 5 2200 216.9 3 2100 232.2 3 1900 198.3 4 2100 205.1 3 2000 175.6 4 2300 307.8 3 2400 269.2 5 2200 224.8 3 2200 171.6 3 2000 0 0 0 0 0 0 1 1 0 1 0 0 1 1 0 1 0 0 0 0 1 0 1 0 1 0 1 1 0 0 1 1 1 0 1 0 1 1 1 1 0 0 0 0 0 0 0 1 0 Distance Location Garage Baths 17 2 1 2 19 4 1 2 12 3 0 2 16 2 1 2.5 28 1 1 1.5 12 1 1 2 15 3 1 2 9 2 1 2.5 18 3 0 1.5 13 4 1 2 14 3 1 2 8 4 1 1.5 7 4 1 2 18 3 1 2 11 3 0 2 16 2 1 2 16 3 0 2 21 4 1 2.5 10 4 1 2 15 4 1 2 8 4 1 2 14 2 1 2.5 20 5 0 1.5 9 4 1 2 11 5 1 3 21 2 1 1.5 26 4 0 2 9 1 1 2 14 3 1 1.5 11 5 0 2 19 3 1 2 11 5 1 2 16 2 1 2 16 2 1 2 10 5 1 2 14 4 1 2.5 19 2 0 2 7 5 1 2.5 19 3 1 2 16 2 1 3 9 3 0 1.5 16 2 1 1.5 19 1 1 1.5 20 4 0 2 24 4 1 2 21 2 1 3 8 5 1 3 17 1 1 2.5 16 4 0 2 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 216.8 192.6 236.4 172.4 251.4 247.5 147.4 181.4 228.4 166.5 189.4 312.1 289.8 269.9 154.3 222.1 209.7 190.9 254.3 207.5 209.7 295.2 176.3 294.3 226.2 126.3 236.8 164.1 217.8 192.2 125.9 220.9 294.5 244.6 201.1 241.3 3 6 5 3 3 6 6 4 3 3 4 7 6 5 2 2 5 3 4 3 4 2 2 7 3 2 4 4 3 2 2 2 6 2 3 4 2200 2200 2200 2200 1900 2300 1700 2200 2300 1600 2200 2400 2000 2200 2000 2100 2200 2200 2500 2100 2200 2100 2000 2400 1900 1900 2600 2300 2500 2400 2400 2300 2700 2300 2500 2600 1 0 1 1 0 0 0 1 1 0 1 1 1 0 1 1 0 0 0 0 0 1 0 1 0 1 0 1 1 0 0 0 1 1 0 1 15 14 20 23 12 7 12 15 17 19 24 13 21 11 13 9 13 18 15 10 19 13 17 8 6 18 17 19 12 16 28 12 15 9 18 13 1 1 3 3 2 3 1 1 5 3 1 3 3 4 2 5 2 3 3 2 2 2 3 4 1 4 5 4 3 2 1 2 3 2 1 4 1 0 1 0 1 1 0 1 1 0 1 1 1 1 0 1 1 1 1 0 1 1 0 1 1 0 1 0 1 1 1 1 1 1 0 1 2 2 2 2 2 3 2 2 1.5 2.5 2 3 3 2.5 2 2 2 2 2 2 2 2.5 2 2 2 1.5 2 2 2 2.5 1.5 2 2 2.5 1.5 2 Price = selling price of house in $thousands Bedrooms = number of bedrooms Size = square feet Pool = binary variable 1 = house has a pool, 0 = no pool Distance = miles to center of city location = what neighborhood the house is located in 1= Mayfair 2= Blueridge 3= Roseland 4= Avondale 5= Wildwood Garage = binary variable 1 = house has a garage, 0 = house has no garage Baths = number of bathrooms BADM 3963 Quantitative Analysis Summer 2017 Schedule Date 6/5 Reading Read text with the learning outcomes in mind, make notes as you read Read textbook chapter 1 Read notes on percentage calculations, graphs Watch podcasts on Excel basics, Graphs 6/6 6/7 Syllabus quiz, CBT Prof Stds, Student Info sheet 6/8 6/9 6/12 Spreadsheet basics quiz Read textbook pg 10-11, problem 1.4 GoalSeek in Excel Read notes on Spreadsheet models Watch podcasts on IF, GOALSEEK, Data tables, profit models 6/13 6/14 6/15 6/16 6/19 6/27 6/28 6/29 6/30 Intro, Percent, graph problems, real estate case homework Ch 1 concepts, graphs, percentage quiz Ch 2 sections 2.1, 2.2, 2.3, 2.8, 2.9, Ch 3 sections 3.1, 3.2, 3.3, 3.4 (optimistic, pessimistic, equal likelihood), 3.5, 3.6 Go over the solved problems at the end of chapters Watch podcast on decision analysis 6/20 6/21 6/22 6/23 6/26 Homework /Quizzes/Exams - due 9pm on the date shown - no late assignments will be accepted Spreadsheet models #1 homework Spreadsheet models #2 homework Read textbook Ch 4, omit section 4.11 Read Supplemental notes on Regression, ANOVA Watch podcasts on regression analysis, correlation, ANOVA Decision Analysis homework Exam 1 Date Reading Read text with the learning outcomes in mind, make notes as you read 7/3 Read textbook Ch 7, sections 7.1,7.2, 7.3, pg 270 Holiday Meal Turkey Ranch - study the formulation Ch 8 - study all formulations, don't worry about solutions yet Read Supplemental LP formulation examples 7/4 7/5 7/6 7/7 7/10 LP formulation homework 1 Read textbook Ch 7, section 7.4 - focus on IsoProfit Line method omit Corner Point Solution method),section 7.5 (omit QM, just look at Excel),sections 7.6, 7.7 Read Supplemental notes on LP graphical solutions, Solving simultaneous linear equations Watch podcasts on graphical method and solving LPs in Excel 7/11 7/12 7/13 7/14 7/17 7/18 7/19 7/20 7/21 7/24 7/25 7/26 7/27 Homework /Quizzes/Tests - due 9pm, - no late assignments will be accepted Regression ANOVA homework LP formulation homework 2 Exam 2 Read Ch 9 Sections 9.1,9.2,9.3 Read Transportation and Assignment Notes Watch podcasts on transportation heuristics LP Solutions homework Transportation/Assignment hmwk Read textbook Ch 11, sections11.1, 11.2 (to pg 406), 11.4 (pg 414), 11.5 Read Supplemental Project Mgmt notes, Watch podcast on Critical Path Method Project management homework Final Exam due Amber Henson 5 9 2 11 10 22 Price 59 23 2.44 90 4.69 5.74 8 3 5 6 2 Dr. Anne M. Davey: Incorrect use of SUM function here 0.3 0.2 0.1 0.5 3.5 3.5 Size 223.1 182.4 222.1 255.6 159.9 275.4 227.2 284.4 234.5 266.6 292.4 211.5 270.8 246.1 2050 2100 2100 2800 1900 2750 2100 2990 2600 2400 2800 1750 2500 2100 Size against Price 3500 3000 2500 Size 2000 1500 1000 500 0 140 50 3 0.17 180 200 220 Price 239.42857 n= Z= p= 160 0.3293675 240 260 280 Price e 240 260 280 300 320 BADM 3963 Quantitative Analysis Summer 2017 Schedule Date 6/5 Reading Read text with the learning outcomes in mind, make notes as you read Read textbook chapter 1 Read notes on percentage calculations, graphs Watch podcasts on Excel basics, Graphs 6/6 6/7 Syllabus quiz, CBT Prof Stds, Student Info sheet 6/8 6/9 6/12 Spreadsheet basics quiz Read textbook pg 10-11, problem 1.4 GoalSeek in Excel Read notes on Spreadsheet models Watch podcasts on IF, GOALSEEK, Data tables, profit models 6/13 6/14 6/15 6/16 6/19 6/27 6/28 6/29 6/30 Intro, Percent, graph problems, real estate case homework Ch 1 concepts, graphs, percentage quiz Ch 2 sections 2.1, 2.2, 2.3, 2.8, 2.9, Ch 3 sections 3.1, 3.2, 3.3, 3.4 (optimistic, pessimistic, equal likelihood), 3.5, 3.6 Go over the solved problems at the end of chapters Watch podcast on decision analysis 6/20 6/21 6/22 6/23 6/26 Homework /Quizzes/Exams - due 9pm on the date shown - no late assignments will be accepted Spreadsheet models #1 homework Spreadsheet models #2 homework Read textbook Ch 4, omit section 4.11 Read Supplemental notes on Regression, ANOVA Watch podcasts on regression analysis, correlation, ANOVA Decision Analysis homework Exam 1 Date Reading Read text with the learning outcomes in mind, make notes as you read 7/3 Read textbook Ch 7, sections 7.1,7.2, 7.3, pg 270 Holiday Meal Turkey Ranch - study the formulation Ch 8 - study all formulations, don't worry about solutions yet Read Supplemental LP formulation examples 7/4 7/5 7/6 7/7 7/10 LP formulation homework 1 Read textbook Ch 7, section 7.4 - focus on IsoProfit Line method omit Corner Point Solution method),section 7.5 (omit QM, just look at Excel),sections 7.6, 7.7 Read Supplemental notes on LP graphical solutions, Solving simultaneous linear equations Watch podcasts on graphical method and solving LPs in Excel 7/11 7/12 7/13 7/14 7/17 7/18 7/19 7/20 7/21 7/24 7/25 7/26 7/27 Homework /Quizzes/Tests - due 9pm, - no late assignments will be accepted Regression ANOVA homework LP formulation homework 2 Exam 2 Read Ch 9 Sections 9.1,9.2,9.3 Read Transportation and Assignment Notes Watch podcasts on transportation heuristics LP Solutions homework Transportation/Assignment hmwk Read textbook Ch 11, sections11.1, 11.2 (to pg 406), 11.4 (pg 414), 11.5 Read Supplemental Project Mgmt notes, Watch podcast on Critical Path Method Project management homework Final Exam due Amber Henson 5 9 2 11 10 22 Price 59 23 2.44 90 4.69 5.74 8 3 5 6 2 Dr. Anne M. Davey: Incorrect use of SUM function here 0.3 0.2 0.1 0.5 3.5 3.5 Size 223.1 182.4 222.1 255.6 159.9 275.4 227.2 284.4 234.5 266.6 292.4 211.5 270.8 246.1 2050 2100 2100 2800 1900 2750 2100 2990 2600 2400 2800 1750 2500 2100 Size against Price 3500 3000 2500 Size 2000 1500 1000 500 0 140 50 3 0.17 180 200 220 Price 239.42857 n= Z= p= 160 0.3293675 240 260 280 Price e 240 260 280 300 320