#  Description  Question  

15406 

Single Tableau Workbook  
15245 
In order to develop new guidelines for identifying consumer debt problems, we have collected a random sample of 100 low and middleclass households to examine the current relationship between the total consumer debt of a household and its income. We estimate that 23% of all U.S. households carry more consumer debt than they can handle. You have been asked to examine the collected data and do two things: (1) provide a thorough analysis of the relationship between the total consumer debt and the income of low to middleincome households, and (2) develop rule of thumb, based on this relationship, for identifying the 23% of all households with serious consumer debt problems. The data are contained in the excel spreadsheet. For each of the 100 households in the random sample, the file contains the total consumer debt (debt) and total income (income) of the household. Note: Regression Analysis  Be sure to include statistical graphs/charts/scatterplots ect… to support analysis. 
guidelines for identifying consumer debt problems  
15226 
In the prerequisite course, Quantitative Reasoning and Analysis, you constructed basic contingency (crosstab) tables. You might be surprised to learn that you can estimate a simple logistic regression model, with a categorical predictor, using the descriptive values presented in the crosstab table. In this assignment, you use Microsoft Excel to construct a specialized tool that creates basic logistic regression models given a crosstab/contingency table. As if that were not useful enough, this Excel tool is not specialized—you can use it given any crosstab/contingency tables you encounter in research. In the field of statistical research, this is just about as exciting as you can get! To prepare · Review the sections in the Osborne text that present a template for constructing an Excel worksheet. · Review the video in the Learning Resources, in which Dr. Matt Jones explains how to harness the power of Excel using contingency tables. · Think about the types of variables that are useful for crosstab tables. By Day 7 The Assignment Using one of the datasets provided, select two variables that allow you to construct a 2×2 contingency table. Use SPSS to run the initial crosstab table, using any two variables that you think are appropriate. Then, use Excel to construct a table in which you report: · Conditional probabilities · Conditional odds · Logits · Odds ratios · Relative risk · Slope Be sure to apply the template from the Osborne text. Note that page 42 has a completed example that should help you determine these values. Be sure to use formulas and cell references in Excel so that the spreadsheet you create can be used as a tool for calculating similar values for other datasets. Once you have created the tool, write a 1 to 2paragraph summary in APA format interpreting your results. Submit both your Excel file and your summary to complete this assignment.
This week’s readings discuss conditional probabilities, conditional odds, logits, odds ratios, relative risk, and slopes. These can all be confusing terms but the good news is that all these values have some relationship to each other. Researchers have their own opinions on which values makes the most sense to report. By Day 3 In a 2 to 3paragraph post, construct a persuasive argument for the value (conditional probability, odds, odds ratio, etc.) that, intuitively, makes the most sense for you to report as a result to your audience. Be sure to provide a specific rationale for your choice.

Assignment: Contingency Tables and Odds in Excel  
15203 
Part 1 As a manager overseeing the development of the concept, you bottle the wine cooler and placed it into distribution in one test store. Your manager has asked you to assess the data and determine the most likely customer based on the ratings. Additionally, your manager would like you to review sales in the test store. Use the Week 3 Data Set to create and calculate the following in Excel®:

Three hundred consumers between 21 and 49  
15186 
Group 1 Case Study: Winter Park Hotel Aaron Smith, Alexandra Smith, Janay Compton, Sabrina Funes, Tyler Melzer EmbryRiddle Aeronautical University
Abstract Group 1 Case Study: Winter Park Hotel [Brief review of the case study goes here ]
Question 1:1. Determine the average amount of time that a guest spends checking in under the current mode of operation. How would this change under each of the stated options?
Answer:
80 guests / 5 lines = 16 guests/hr 60 minutes / 3.2 minutes per register = 18.75 min 1 server 1/(µÆ›) = 1/(18.75 – 16) = .3636 ~21.81 min
The current line operation will result in guests waiting 21.81 minutes to check in
Option 1: With 30% (~24 out of 80 guests) of the gusts using the rerouted line and clerk can serve a new guest every 2 minutes. This will result in an average wait time of: 1/(µÆ›) = 1/(3024) = .1667 .1667 * 60 minutes = 10 minutes With 56 guests remaining, they would then work with the other 4 clerks for check in. 56 guests / 4 clerks = 14 guests/hr Average wait time = 3.8 minutes (.0633/hr) 1/.0633 = 15.79 guests per hour 1/(µÆ›) = 1/(15.7914) = .55866/ hr (~33.52 minutes) To compute a mean time for the guests wait times: 30%*10 + 70%*33.5 = 26.45 minutes
Option 2: Using the data presented in the problem, the below QM was generated:
With an average time of .101 in the system (Ws), this equates to 6.1 minutes, much faster than what was presented in option 1.
Option 3: 60/3 = 20 guests/hr that can be served at the ATM 1/(µÆ›) = 1/(2016) = .25 hrs (~15 minutes) on average a guest will wait during the check in process 80 guests – 16 guests/hr = 64
With an average time of .087 in the system (Ws), this equates to 5.2 minutes. 20%*(15) + .8*(5.2) = 7.2 minutes, not as fast as option 2.
2. Question 2: Which option do you recommend?
Answer:
Option 2 would be the most recommended option. With 5 clerks, an average time of .101 in the system which equates to 6.1 minutes, this is the least waiting time out of each of the plans.
3. Question 3: What other considerations or limitations should be considered/evaluated?
Answer:
References Render, B. (2014). Quantitative analysis for management (12., global ed. ed.). Boston [u.a.]: Pearson
Activity 8.7 – Group Case Study: Winter Park Hotel
Donna Shader, manager of the Winter Park Hotel, is considering how to restructure the front desk to reach an optimum level of staff efficiency and guest service. At present, the hotel has five clerks on duty, each with a separate waiting line, during the peak checkin time of 3:00 pm. To 5:00 pm. Observation of arrivals during this time shows that an average of 80 guests arrive each hour (although there is no upward limit on the number that could arrive at any given time). It takes an average of 3.2 minutes for each frontdesk clerk to register each guest. Donna is considering three plans for improving guest service by reducing the length of time guests spend waiting in line.
The first proposal would designate one employee as a quickservice clerk for guests registering under corporate accounts, a market segment that fills about 30% of all occupied rooms. Because corporate guests are preregistered, their registration takes just 2 minutes. With these guests separated from the rest of the clientele, the average time for registering a typical guest would climb to 3.8 minutes. Under Plan 1, noncorporate guests would choose any of the remaining four lines.
The second plan is to implement a singleline system. All guests could form a single waiting line to be served by whichever of five clerks became available. This option would require sufficient lobby space for what could be a substantial queue.
The third proposal involves using an automatic teller machine (ATM) for checkins. This ATM would provide a service just slightly better than a clerk, 3.0 minutes. Given that initial use of this technology might be minimal, Shader estimates that 20% of customers, primarily frequent guests, would be willing to use the machines. (This might be a conservative estimate if the guests perceive direct benefits from using the ATM, as bank customers do. Citibank reports that some 95% of its Manhattan customers use its ATMs.) Donna would set up a single queue for customers who prefer human checkin clerks. This would be served by the five clerks, although Donna is hopeful that the machine will allow a reduction to four.
Discussion Questions
1. Determine the average amount of time that a guest spends checking in under the current mode of operation. How would this change under each of the stated options? 2. Which option do you recommend? 3. What other considerations or limitations should be considered/evaluated?

Please only answer question 3  
15185 
Complete the following problems and submit the results in either a Microsoft Word document or a Microsoft Excel spreadsheet. If you choose to use an Excel spreadsheet, place each problem on a separate sheet and label the tab with problem number. Save your document with a descriptive file name, including the assignment and your name. QM software will be extremely helpful. Quantitative Analysis for Management (12th Edition) Render, Barry Activity 8.6 – Module Problems
Complete the following problems and submit the results in either a Microsoft Word document or a
Microsoft Excel spreadsheet. If you choose to use an Excel spreadsheet, place each problem on a separate sheet and label the tab with problem number. Save your document with a descriptive file name, including the assignment and your name.
Chapter 9
Chapter 12
81 Bechtold Construction is in the process of installing power lines to a large housing development. Steve Bechtold wants to minimize the total length of wire used, which will minimize his costs. The housing development is shown as a network. Each house has been numbered, and the distances between houses are given in hundreds of feet. a. What is the required length of power line required? b. What is the recommended route for the lines?
House 7 is currently being demolished and will be removed from the system.
c. With that change, what will be the requirement for power lines and what will the route be?
82 The Rockwell Electronics Corporation retains a service crew to repair machine breakdowns that occur on an average of 3 per day (approximately Poisson in nature). The crew can service an average of 8 machines per day, with a repair time distribution that resembles the exponential distribution. a. What is the utilization rate of this service system? b. What is the average downtime for a machine that is broken? c. How many machines are waiting to be serviced at any given time? d. What is the probability that more than one machine is in the system? e. What is the probability that more than two are broken and waiting to be repaired or being serviced? f. What is the probability that more than three are in the system? g. What is the probability that more than four are in the system?
83 Mike Dreskin manages a large Los Angeles movie theater complex called Cinema I, II, III, and IV. Each of the four auditoriums plays a different film; the schedule is set so that starting times are staggered to avoid the large crowds that would occur if all four movies started at the same time. The theater has a single ticket booth and a cashier who can maintain an average service rate of 225 movie patrons per hour. Service times are assumed to follow an exponential distribution. Arrivals on a typically active day are Poisson distributed and average 210 per hour. To determine the efficiency of the current ticket operation, Mike wishes to examine several queue operating characteristics.
84 The wheat harvesting season in the American Midwest is short, and most farmers deliver their truckloads of wheat to a giant central storage bin within a twoweek span. Because of this, wheat filled trucks waiting to unload and return to the fields have been known to back up for a block at the receiving bin. The central bin is owned cooperatively, and it is to every farmer’s benefit to make the unloading/storage process as efficient as possible. The cost of grain deterioration caused by unloading delays, the cost of truck rental, and idle driver time are significant concerns to the coop members. Although farmers have difficulty quantifying crop damage, it is easy to assign a waiting and unloading cost for truck and driver of $58 per hour. The storage bin is open and operated 16 hours per day, 7 days per week, during the harvest season and is capable of unloading 32 trucks per hour according to an exponential distribution. Full trucks arrive all day long (during the hours the bin is open) at a rate of about 30 per hour, following a Poisson pattern. To help the cooperative get a handle on the problem of lost time while trucks are waiting in line or unloading at the bin, find the:
The cooperative uses the storage bin only two weeks per year. Farmers estimate that enlarging the bin would cut unloading costs by 50% next year. It will cost $9,000 to do so during the offseason. f. Would it be worth the cooperative’s while to enlarge the storage area?
85 Juhn and Sons Wholesale Fruit Distributors employ one worker whose job is to load fruit on outgoing company trucks. Trucks arrive at the loading gate at an average of 26 per day, or
3.25 per hour, according to a Poisson distribution. The worker loads them at a rate of 4 per hour, following approximately the exponential distribution in service times. Determine the operating characteristics of this loading gate problem [the utilization rate, time and number in the system and in the queue]. What is the probability that there will be three or more trucks either being loaded or waiting? Discuss the results of your queuing model computation.
Juhn believes that adding a second fruit loader will substantially improve the firm’s efficiency. He estimates that a twoperson crew, still acting like a singleserver system, at the loading gate will double the loading rate from 4 trucks per hour to 8 trucks per hour. Analyze the effect on the queue of such a change and compare the results with those found in (a) above [the utilization rate, time and number in the system and in the queue].
Truck drivers working for Juhn and Sons are paid a salary of $30 per hour on average. Fruit loaders receive about $18 per hour. Truck drivers waiting in the queue or at the loading gate are drawing a salary but are productively idle and unable to generate revenue during that time. What would be the hourly cost savings to the firm associated with employing two loaders instead of one?
Juhn and Sons are considering building a second platform or gate to speed the process of loading their fruit trucks. This, they think, will be even more efficient than simply hiring another loader to help out the first platform and will not require any more loaders that it will to put both loaders on one dock. Assume that workers at each platform will be able to load 4 trucks per hour each and that trucks will continue to arrive at the rate of 3.25 per hour. Find the waiting line’s new operating conditions [the utilization rate, time and number in the system and in the queue]. Is this new approach indeed speedier than the other two already considered?
86 Customers arrive at an automated coffee vending machine at a rate of 3 per minute, following a Poisson distribution. The coffee machine dispenses a cup of coffee in exactly 15 seconds.
You may submit just the answers or you may submit the answers and the QM worksheets you used to arrive at the answer. Choosing the latter will afford instructors the opportunity to review your work and determine if you understand the concept but have made some minor computational error, therefore allowing them to assign some credit based on your understanding. Submitting just the answers does not provide for any partial credit. 
QM software will be extremely helpful.  
15108 
Week 5  Final Paper Final Paper The Final Paper provides you with an opportunity to integrate and reflect on what you have learned during the class. The question to address is: “What have you learned about statistics?” In developing your responses, consider—at a minimum—and discuss the application of each of the course elements in analyzing and making decisions about data (counts and/or measurements). In your paper, · Discuss the following course elements: o Descriptive statistics o Inferential statistics o Hypothesis development and testing o Selection of appropriate statistical tests o Evaluating statistical results. The Final Paper · Must be three to five doublespaced pages in length (not including title and references pages) and formatted according to APA style as outlined in the Ashford Writing Center (Links to an external site.)Links to an external site.. · Must include a separate title page with the following: o Title of paper o Student’s name o Course name and number o Instructor’s name o Date submitted · Must begin with an introductory paragraph that has a succinct thesis statement. · Must address the topic of the paper with critical thought. · Must end with a conclusion that reaffirms your thesis. · Must use at least three scholarly sources in addition to the course text. · Must document all sources in APA style as outlined in the Ashford Writing Center · Must include a separate references page that is formatted according to APA style as outlined in the Ashford Writing Center.

Must be 4 doublespaced pages in length  
15075 
Due Week 10 Imagine you are a manager at a major bottling company. Customers have begun to complain that the bottles of the brand of soda produced in your company contain less than the advertised sixteen (16) ounces of product. Your boss wants to solve the problem at hand and has asked you to investigate. You have your employees pull thirty (30) bottles off the line at random from all the shifts at the bottling plant. You ask your employees to measure the amount of soda there is in each bottle. Note: Use the data set provided by your instructor to complete this assignment.
Write a two to three (23) page report in which you:
a. If you conclude that there are less than sixteen (16) ounces in a bottle of soda, speculate on three (3) possible causes. Next, suggest the strategies to avoid the deficit in the future.
Or
b. If you conclude that the claim of less soda per bottle is not supported or justified, provide a detailed explanation to your boss about the situation. Include your speculation on the reason(s) behind the claim, and recommend one (1) strategy geared toward mitigating this issue in the future.
Your assignment must follow these formatting requirements:
The specific course learning outcomes associated with this assignment are:
Assignment 1: Bottling Company Case Study
Author’s Name
Strayer University
MAT300
Date
Assignment 1: Bottling Company Case Study
Introduction
Begin your first paragraph here. The paper will be doublespaced throughout, including the references page. Be sure to indent each new paragraph. Your paper must be typed, double spaced throughout (including the references page), using Times New Roman font (size 12), with oneinch margins on all sides (American Psychological Association, 2010). No citations and references are required, but if you use them, they must follow APA format. Check with your professor for any additional instructions. You must include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. This is already set up for you in the template, so just enter your name where it says Author’s Name. The cover page and the reference page are not included in the required assignment page length. Data Set You can share the data you used for your assignment in this section. Descriptive Statistics In this section, please calculate the mean, median, and standard deviation for ounces in the bottles based on the data provided to you by your instructor. Confidence Interval Construct a 95% Confidence Interval for the ounces in the bottles. Provide an interpretation of the confidence interval so that your manager would understand it. Hypothesis Test Conduct a hypothesis test to verify if the claim that a bottle contains less than sixteen (16) ounces is supported. Clearly state the logic of your test, the calculations, and the conclusion of your test. Remember the conclusion is more than just a reject the null or fail to reject the null, you have to state how the conclusion affects the customer’s claim. Discussion and Conclusion You have two options for the discussion. If you conclude that there are less than sixteen (16) ounces in a bottle of soda, speculate on three (3) possible causes. Next, suggest the strategies to avoid the deficit in the future. Or If you conclude that the claim of less soda per bottle is not supported or justified, provide a detailed explanation to your boss about the situation. Include your speculation on the reason(s) behind the claim, and recommend one (1) strategy geared toward mitigating this issue in the future. *You do not have to use outside sources for your paper. If you decided to use them, you must followup APA guidelines. Because of the complexity of APA, I recommend you take one of two easy routes to cite references. One way is to find a good example and follow it closely. Another is to use the Strayer University Library’s resources that allow cutandpaste references. Even with cutandpaste, though, there can be issues. Here’s what instructors will look for in your references: no first names of authors (only use initials); no ALL CAPS titles; italicized book and article titles; year/date published (in parenthesis). Here is a website that makes creating citations much easier: http://www.citefast.com/?s=APA . Why should you use outside sources? The first reason is that our papers will be more persuasive if we’re using reliable, authoritative information, and we want to remind our reader that we didn’t just make stuff up. Using authoritative references creates an authoritative paper. The second reason is that we want to avoid plagiarism penalties. Plagiarism can get us kicked out of school, and we’re here to get a degree, so we want to remain enrolled. Plagiarism can be avoided by simply letting your reader know where you found your information. For instance, if I tell you Bill Atkinson sold HyperCard to Apple for $100,000 dollars, I may be making it up. If I instead tell you Levy (2011, p. 15) reminds us that HyperCard was sold to Apple for $100,000 dollars by Bill Atkinson, you’ll be able to use my references list and look it up to help determine whether you want to believe me. If it’s on your reference page, it needs to be referred to in your paper. If you’ve referred to it in your paper, it needs to be on your list of references. There should be no items on your reference page that don’t also include a parenthetical reference in your paper. If it’s listed as a reference, it must be mentioned in your paper. So there you have it. Make your paper look like an APA paper. List your references. Refer to those references in your paper. And use this paper as a template if you like.
References American Psychological Association. (2010). Publication manual of the American Psychological Association. Washington, DC: American Psychological Association. Levy, S. (2011). In the plex: How Google thinks, works, and shapes our lives. New York: Simon & Schuster.

Assignment 1: Bottling Company Case Study<  
15006 
MGT 226 PACE University 2018 Dr. Kuei Selfassessment (draft)  (before) Midterm
Name: In accordance with the Honor Code, I certify that my answers here are my own work
Be sure to read each question carefully, to ask for explanation if you do not understand a question (however, please don't ask your instructor about solution procedures/strategies).
In total, there are two sections: Part 1 (question) (Total: 13 points) Part 2 – (multiple choice  Total: 32 points)(2 Points Each)
Part 1 (Total:13 points) please don't ask your instructor about solution procedures/strategies 1. (8 points) Big Hart Manufacturing makes three products. One of them is Star War Lego Product 001. The cost of producing the Star War Lego Product 001 includes a setup cost of $500,000 and a unit cost of $75 per unit produced.
The demand per year for the Star War Lego Product 001 is a function of its selling price (i.e. p). Marketing experts estimate that there is a demand for 20,000 units, if it were free, and that this demand shrinks by 80 units for every dollar in the price of the product. As a result, demand is a linear function, namely, Demand (D) or Volume (V) = 20,00080*p. p is the price of Star War Lego Product 001. Big Hart Manufacturing plans to sell Star War Lego Product 001 for $162. Build a spreadsheet model in Excel to calculate the profit/loss for a given demand. Question 1 (2 points): Create an influence diagram.
Hint:
Your Answer: =____________________ Your Answer: =_____________________
Question 2 (1 point): Define the decision variable.
Your Answer: _____________________
Question 3 (5 points): Use a data table that varies price from $70 to $210 increment of $10 to find the price range that maximizes profit.
Hint:
Your Answer: _____________________ 2. (5 points) The Byte computer company produces two models of computers, Plain and Fancy. It wants to plan how many computers to produce next month to maximize profits. Producing these computers requires wiring, assembly and inspection time. Each computer produces a certain level of profits but faces a limited demand. There are a limited number of wiring, assembly and inspection hours available next month. The data for this problem is summarized in the following table.
Let X1 = Number of Plain computers produce X2 = Number of Fancy computers to produce
Formulate the LP model for this problem. ________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________
*** (After Final) Announcement*** Now that the grades are final I will NOT: Change your grade once that is determined
Part 2 (you must answer all 16 questions in this section) (multiple choice  Total: 32 points)(2 Points Each) please don't ask your instructor about solution procedures/strategies
______1. What does the Excel "=SUMPRODUCT(A1:A5,C6;C10)" function do? a. Sums each range and multiplies the sums. b. Sum each pair of cells and multiples each sum. c. Multiplies the contents of cells containing the =SUM() command. d. Multiplies each pair of cells in two arrays matched by position and sums the products.
______2. Which of the following analytical techniques helps us arrive at the best decision (i.e. determine the best ways to operate and balance all constraints)? a. Predictive analytics b. Data mining c. Prescriptive analytics d. Descriptive analytics
_______3. Which of the following gives the proportion of items in each bin? a. Frequency b. Percent frequency c. Relative frequency d. Bin proportion _____4. For data having a bellshaped distribution (i.e. Normal distribution), approximately _____ percent of the data values will be within one standard deviation of the mean.
a. 95 b. 66 c. 68 d. 97
____5. Any data value with a zscore less than –3 or greater than +3 is treated as a(n) a. Outlier (i.e. defective item). b. usual value. c. Nondefective value. d. zscore value. ______6. Camm Industries produces different types of raw materials and it is interested in using simulation to estimate the profit per unit for its new product X. The selling price for the product will be $40 per unit. Probability distributions for the raw material cost, the production cost, and the marketing cost are estimated as follows:
Compute profit per unit for the worst case. a. 0 b. 3 c. 5 d. 9 e. None of the above
______7. The following linear programming problem has been written to plan the production of two products. The company wants to maximize its profits. X1 = number of product 1 produced in each batch X2 = number of product 2 produced in each batch MAX: 150 X1 + 250 X2 Subject to: 2 X1 + 5 X2 ≤ 200 − resource 1 3 X1 + 7 X2 ≤ 175 − resource 2 X1, X2 ≥ 0 How many units of resource 2 are consumed by each unit of product 1 produced? a. 1 b. 2 c. 3 d. 5
The following business story pertains to questions 8 to 9
Jones Furniture Company produces beds and desks for college students. The production process requires carpentry and varnishing. Each bed requires 6 hours of carpentry and 4 hour of varnishing. Each desk requires 4 hours of carpentry and 8 hours of varnishing. There are 36 hours of carpentry time and 40 hours of varnishing time available. Beds generate $30 of profit and desks generate $40 of profit. Demand for desks is limited, so at most 8 will be produced. Let X1 = Number of Beds to produce X2 = Number of Desks to produce
The LP model for the problem is
MAX: 30 X1 + 40 X2 Subject to: 6 X1 + 4 X2 ≤ 36 (carpentry) 4 X1 + 8 X2 ≤ 40 (varnishing) X2 ≤ 8 (demand for desks) X1, X2 ≥ 0 Exhibit 1
_____8. Refer to Exhibit 1. Which of the following statements represent the carpentry, varnishing and limited demand for desks constraints? a. B4:C4 ≤ B5:C5 b. E5 ≤ 0 c. D8:D10 ≤ E8:E10 d. E8:E10 ≤ D8:D10
______9. Refer to Exhibit 1. What formula should be entered in cell E5 (i.e. objective function) in the accompanying Excel spreadsheet to compute total profit? a. =B4*B5+C4*C5 b. =SUMPRODUCT(B8:C8,$B$4:$C$4) c. =SUM(B5:C5) d. =SUM(E8:E10)
______10. A manager is simulating the number of times a machine operator stops a machine to make adjustments. After careful study the manager found that the number of stops ranged from one to four per cycle and that each number of stops was equally likely. Using the random numbers 0.6380 and 0.8549 (in that order), the next two simulated cycles would respectively have stops for adjustment of:
_____11. Tim wishes to invest his inheritance of $100,000 so that his return on investment is maximized, but he also wishes to keep his risk level relatively low. He has decided to invest his money in any of three possible ways: CDS, which pay a guaranteed 8 percent; stocks, which have an expected return of 12 percent; and a money market mutual fund, which is expected to return 10 percent. In formulating this as a linear programming problem, Tim defines the variables as follows: C=dollars invested in CDs; S=dollars invested in stocks; M=dollars invested in money market mutual fund. What would the objective function be? a) max 0.08C+0.12S+0.1M, b) max C+S+M, c) max 10000(0.08C+0.12S+0.1M), d) max 0.3C+0.3S+0.3M, e) none of the above.
_____12. Given the following frequency distribution, the random number 0.1703 would be interpreted as a demand of:
______13. The following are two constraints: ; If and , what are the values for ? (a) 12, (b) 6, (c) 2, (d) 0, (e)
_____14. (Given the following small project) When will the project be completed?
a) 14, b) 11, c) 16, d) 20, e) none of the above.
15. The Investment Club at Bell Labs has solicited and obtained $50,000 from its members. Collectively, the members have selected the three stocks, two bond funds, and a taxdeferred annuity shown in the following table as possible investments (let Xi=$ invested in option i, i=1, 2, 3, 4, 5, and 6). Formulate and solve a linear program that will maximize the total projected annual return subject to the conditions set forth by the Investment Club members.
The club members have decided on the following strategies for investment:
· All $50,000 is to be invested. · At least $10,000 is to be invested in the taxdeferred annuity. · At least 25% of the funds invested in stocks are to be in the lowrisk stock (i.e. TAT). · No more than $12,500 of the total investment is to be placed in investments with projected annual returns of less than 10% (i.e. TAT, Short term Bonds, and Taxdeferred annuity) · At least as much is to be invested in bonds as stocks.
_____15. One typo can be found in (a) cell B7, (b) cell B9, (c) cell B18, (d) cell B21, (e) cell D10, (f) I7, (g) none of the above.
_____16. The _____ value for each lessthanorequalto constraint indicates the difference between the lefthand and righthand values for a constraint. a. objective function coefficient b. slack c. unbounded d. surplus
*** (After Final) Announcement*** Now that the grades are final I will NOT: Change your grade once that is determined 
In accordance with the Honor Code, I certify that my answers here are my own work  
15003 
Create a new file for each of the following 3 variations of the TV Advertising Problem studied in class. Please note the following important items: · Name your 3 files LastnameAsmt41.xlsx, LastnameAsmt42.xlsx, and LastnameAsmt43.xlsx. · Email them to me by 3:00 PM next Thursday, attaching all three files to one email. Send the email from your SFSU email account to avoid it being flagged as spam by the SFSU server and not reaching me. · On each problem, start with the original problem formulation solved with integer constraints on all decision variables. Include these integer constraints on all 3 problems.
1. (5 pts.) In addition to the constraints in the original advertising problem, suppose that General Flakes also wants to obtain at least 180 million exposures to men, and at least 160 million exposures to women. 1a) How far off is the original model’s optimal solution from satisfying each of these two conditions? 1b) Modify the model to ensure these conditions are met; rerun Solver to find a new optimal solution. 1c) How much does the optimal total cost increase compared to that of the original model?
2. (5 pts.) Return to the original advertising model (i.e., ignore the conditions of problem 1 above). Suppose that General Flakes decides it will place at most 10 ads on any given show. 2a) Modify the model to incorporate this condition, and then reoptimize to find the new optimal solution. How much does satisfying this condition cost GFC compared to the optimal solution for the original problem? 2b) Run a sensitivity analysis (either via SolverTable or manually with Solver, copying and pasting the results as needed) to see how sensitive the optimal solution (ad strategy) and total costs are to the maximum number of ads allowed on any one show. Let the maximum number of ads on any one show range from 5 to 17 in increments of 2 (i.e., use 5, 7, 9, …, 17). 2c) Make a chart (“tradeoff curve”) from the results showing how total costs change as a function of the maximum number of ads allowed.
3. (5 pts.) In the dualobjective version of the advertising model, we maximized the total number of excess exposures while placing a budget constraint on the total advertising cost. 3a) Go back to minimizing the total advertising cost but add a constraint that places a lower limit on the total number of excess exposures, i.e., Total Number of Excess Exposures ≥ 0 (the lower limit is 0). 3b) Run a sensitivity analysis on this lower limit (either via SolverTable or manually with Solver, copying and pasting the results as needed), where the range of values goes from 0 to 50 in increments of 5. Report both the optimal ad strategy and its total cost. 3c) Make a tradeoff curve from the results showing how total costs change as a function of the lower limit on the total number of excess exposures.

excel sheet do #2 and #3. I already finished half of the work. just need to run the solver table and answer all the question  
14993 
Lecture 2 – Correlation Assignment Scatter plot1 point, each correlation by hand 4 points, each coefficient of determination 2 point
then
1. For the following data, create a scatter plot (1) and calculate the correlation by hand (3).
2. Compute the correlation coefficient for the following data set 3. Compute the coefficient of determination for the following data set
4. Compute the correlation coefficient for the following data set
5. Compute the correlation coefficient for the following data set
6. Compute the correlation coefficient for the following data set 7. Compute the coefficient of determination for the following data set

Need someone can do statistics HW. if you do not have rate do not chat or email me  
14990 