Here is the other assignment for Quantitative Methods, Thank You!!!

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. BADM 3963 Summer 2017 Spreadsheet quiz Problem #1 will be done in an Excel spreadsheet file, enter #2 answers in the table in this file. Submit both files in Blackboard Assignments (remember to attach both files before submitting) 1. Open a new spreadsheet and enter the data as shown below: Put your name in cell A1 a. Use Excel operations, functions and cell addresses to do the following operations in the cells given. I must be able to see your functions and formulas by toggling formulas - If just numbers are typed into ANY of the results cells, you will receive 0 for this quiz. Result Cell Operations C4 the sum of cells A4 through A9 C5 the sum of A6 and A8 C6 A9 divided by A5 C7 the product of A5 and A8 C8 the square root of A9 (you may have to see EXCEL help for the square root function) C9 the square root of the sum of A9 and A7 C10 The difference between A8 and A6 C30 the average price (use the appropriate Excel function) b. Use the data in cells A14 through B28 to create a scatterplot - size and place the graph so It fits in rows 14-28 beside the data c. Use the data in cells H4 through I7 and enter the following calculation in cell H9: =H4*i4+H5*i5+H6*i6+H7*i7 d. Now use the SUMPRODUCT function to do the same calculation in cell H10 e. Create the formula shown below in cell E33, using the corresponding data in Cells B33-B35 to calculate X (be careful with brackets here - remember the order of operations, Excel will follow them unless you use brackets correctly) X p Z p (1 p ) n Enter your name here: AMBER HENSON 2. Determine the numerical results that you would expect to be returned by the formulas in the following spreadsheet. Type your answers in the column to the right of the formulas. A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 B Simon Pie Co. Weekly Profit Model Input Data/Parameters Selling Price per Pie $10 Unit Pie Processing cost ($ per pie) Unit Cost, Fruit Filling ($ per pie) Unit Cost, Dough ($ per pie) Fixed Cost ($ per week) =IF(B13 20, 1.75, 2.05) 10 Decision variables: Pies made/sold per week Assume all made can be sold 25 Outputs - Financial results $ per week Total revenue =B13*B5 Total processing cost Total ingredients cost Fixed costs Total Cost =B13*B7 =B13*(B8+B9) =B10 =sum(B19:B21) Total Profit =B17-B22 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 D E F G H Formulas used =sum(A4:A9) =A6+A8 =A9/A5 =A5*A8 =SQRT(A9) =SQRT(A9+A7) =A8-A6 I 3 5 6 2 J K 0.3 0.2 0.1 0.5 3.5 =h4*i4+h5*i5+h6*i6+h7*i7 3.5 =sumproduct(H4:H7, I4:I7) Price vs Size 3500 3000 2500 Size A B C 1 SS basics quiz summer 2017 2 3 4 5 59 5 9 12 6 2 2.44 7 11 90 8 10 4.69 9 22 5.74 10 8 11 12 13 14 Price Size 15 223.1 2050 16 182.4 2100 17 222.1 2100 18 255.6 2800 19 159.9 1900 20 275.4 2750 21 227.2 2100 22 284.4 2990 23 234.5 2600 24 266.6 2400 25 292.4 2800 26 211.5 1750 27 270.8 2500 28 246.1 2100 29 30 239.43 =AVERAGE(A15:A28) 31 32 33 n= 50 34 Z= 3 35 p= 0.17 36 37 38 2000 1500 1000 500 0 0 50 100 150 200 Price 0.3294 =B35+B34*SQRT((B35*(1-B35))/B33) X pZ p (1 p ) n 250 300 350 L 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 D E F G H Formulas used =sum(A4:A9) =A6+A8 =A9/A5 =A5*A8 =SQRT(A9) =SQRT(A9+A7) =A8-A6 I 3 5 6 2 J K 0.3 0.2 0.1 0.5 3.5 =h4*i4+h5*i5+h6*i6+h7*i7 3.5 =sumproduct(H4:H7, I4:I7) Price vs Size 3500 3000 2500 Size A B C 1 SS basics quiz summer 2017 2 3 4 5 59 5 9 12 6 2 2.44 7 11 90 8 10 4.69 9 22 5.74 10 8 11 12 13 14 Price Size 15 223.1 2050 16 182.4 2100 17 222.1 2100 18 255.6 2800 19 159.9 1900 20 275.4 2750 21 227.2 2100 22 284.4 2990 23 234.5 2600 24 266.6 2400 25 292.4 2800 26 211.5 1750 27 270.8 2500 28 246.1 2100 29 30 239.43 =AVERAGE(A15:A28) 31 32 33 n= 50 34 Z= 3 35 p= 0.17 36 37 38 2000 1500 1000 500 0 0 50 100 150 200 Price 0.3294 =B35+B34*SQRT((B35*(1-B35))/B33) X pZ p (1 p ) n 250 300 350 L