Statistics Homework Help


Questions

# Description Question
15406

 

1. On Blackboard: Single Tableau Workbook file.

Name the file,

"lastname firstname Viz1.twb" a. It should

             _         _

show all of the visuals you have created

2.   On Tableau Public, publish your dashboard.

3.                Single Memo PDF of 5 "main points". Name the file, "lastname _firstname _ Viz l.pdf"

You will be graded on :. Professional appearance - appearance sells !

i) No typos

ii) ii) Appropriate titles, axis labels, data labels iii) iii) Appropriate font size

iiii) iv) Neat appearance

• Creative and effective communication

i) The best dashboards will have creative (but proper) use of color.

ii) ii) The best dashboards will "layer" several points appropriately onto each visual, but will not suffer from "information overload.

iii) iii) Using only the standard, "default" versions of each visual will not earn you the most points

iiii) iv) Each of your main points need to be understood by the audience within 30 seconds of looking at your visual.

v) v) Appropriate use of text on the viz (use text to convey points, but should be concise and not overly wordy).

e. • Clear, concise, and succinct reporting of statistical results (round to 2 decimal places)

f. Compliance with the outlined procedure above


 

Data Viz: Dashboard

1. Create the following graphs/charts in Tableau ( parts (e) _ (h) are required to be on your poster):e. A frequency distribution or histogram,f. A bar chart.g. A scatter plot (continuous data only) to analyze the relationship between two variables, and h. One of the following: map, line graph, area graph, bubble chart, heat map, or word cloud.

2. Create a descriptive statistics table with the following: mean, median, mode, standard deviation, coefficient of variation, minimum, maximum, and number of observations.

3. Create the Dashboard in Tableau and publish on Tableau Public.

5 points Memo:

1. Write a professional memo (addressed to me) outlining the 5 main points you want the audience to learn from your viz (Can be done in Microsoft Word and SAVED AS A PDF). Print out and tum in to me in class.

All graphs (including axes) and tables should be labeled and titled appropriately. Formatting should be consistent across graphs.What you will need to turn in:

I. On Blackboard: Single Tableau Workbook file.

Name the file,

"lastname firstname Viz1.twb" a. It should

             _         _

show all of the visuals you have created

2.   On Tableau Public, publish your dashboard.

3.                  Single Memo PDF of 5 "main points". Name the file, "lastname_firstname_ Viz l.pdf"

You will be graded on :. Professional appearance _ appearance sells !

i) No typos

ii) ii) Appropriate titles, axis labels, data labels


 

.111 T-Mobile

9:11 AM

'" @ f • 100

+

Done

I nstructi ons .docx

Data Visualization Dashboard

This project is designed to hone your skills to use data to convey statistical information via a visualization. You will need to find a topic that interests you, formulate a "question", and use statistical analysis to tell a story about that question. Next, you will find a way to convey the main points of your project to others.

The visual will take the form of a Dashboard which you will publish on Tableau Public. The point of this exercise is to use your statistical skills to educate your audience about a topic. For example, "Is climate change "real" ?", "Is now the best time to buy a house ?", "Does trickle-down economics work?", "Should I buy health insurance through a healthcare exchange ?", "Why are movie ticket sales declining?" "Is there a connection between economic growth and income inequality?" etc.

Data Requirements:

Find a dataset containing at least 4 variables minmum. Your dataset MUST satisfy the following criteria:

a. at least one quantitative variable,

b.    at least one qualitative (categorical) variable,

c.    at least one discrete variable, and

d.   at least one continuous variable.

Data Viz: Dashboard

1. Create the following graphs/charts in Tableau ( parts (e) - (h) are required to be on your poster):e. A frequency distribution or

_____ _.,,_._., o±A-~~.f_A____h_f'1_""'_D..b_O.:t~-.A.._C1L'o ~___ta_.~~k+ ______________________________ _


 

Criteria

A : Outstandi~g.

I

B : Proficient

I

 

C: Basic

_I D/F: Below E~p~etations

Completed

All portions of the assigrnucm, induding prescmarions, data preparation, and visualizations were attempted and subrnirrcd

assignment per

requirements

 

 

This is. :I pass I fail compooenr.

AU or no points ':'Ire awarded.

 

 

 

 

Data IS appropriate hut

 

D:n:'l is related but not

D:lt.'l has lillie or oo relation

Data is

The dara set chosen (Jr used

 

 

[0 die ('PIC being explored,

appropriate and

by is appropriate, correct,

 

minor data issues mar be

 

sufficient 10 supfXln me

errors will lead rc incorrect

sufficient for

and sufficient 10 suPPOrt the

 

prc.c;em or enhancements

 

analysis, or signlficanr cbla

conclusion. :1ndl or (I:'IL'l

 

l1"1a), he- needed fora proper

 

is .. sues prevenr a clear

the analysis

thesis of the analysis.

 

analysis.

 

reading <If the resuhs.

issues nuke the ':'In:.llp:iis

 

 

 

 

 

unusable.

Headers,

Clear direction is provided.

 

 

 

 

'l1le USd" must self-discover

The user h:t. s little or no

 

Header, footers, and

 

indication of how to engage.

dirccdons,

Visual cues, roolrips, and

 

 

funcdonahry, Headers and

citations, and

cirarions arc consiseendy and

 

instructions are present. bur

 

footers m:'ly he missing.

Dlrccrions are missing on

 

visual cues may be missing

 

dear. Missing bcaders and

visual cues arc

corrccrty employed co

 

or could he improved.

 

Difficult ro know whar W

footers for context and

given as guides

inform and guide,

 

 

 

 

 

do,

 

meaning,

Basic

Chan Iypes are suitable and

 

Chan types chosen arc

 

Charts incorrectly used for

Difficult to understand wbar

visualization

best options f(lf the analysis.

 

 

is intended wilh the chart and

rules and best

All axes and text are treated

 

acceptable, bur axes ma), be

 

the purpoSC' Intended.

Axes

dnra. Color :lcu\'d)' disrracrs

 

clorrcrcd <II' have rotated

 

arc difficclr to read and

practices arc

appropriarely. The

 

text. Color choices

 

derracr from understanding,

and confuses, Ch:art junk

conaistcntly

applicacion of color is

 

 

dominates the visualization

applied and

C(Jfrect and clearly conv<':ys

 

commurucarc mC:lllJng but

 

Color Uscc:11O a disseacring

and the meaning is

demonstrated

meaning,

 

can be improved.

 

or unsuieablc manner,

unreadable.

The

 

 

 

 

 

 

 

 

 

 

v -isualiaarion

The visualization f:tcilit':'ltC!>

 

Study is required ro interpret

 

The visuaheuion (1()CS nor

The visuahzanon L s

allows the user

quid: cognition and lC:lding

 

the data and how it applies

 

dirccrly address the ropic (J(

completely imppropriarc aod

to conduc-t the

10:l fact-bar s cd conclusion

 

to mc rhexis of che analysis.

 

relics on prcscnradon

cannot be u$.C<1 to conduce

intended

or asscruon.

 

 

 

suPP(Jtt.

 

the intended analysis.

analysis

 

 

 

 

 

 

 

 

 

 

Viz is clean,

The 4<:' •• arc well

 

Aspects (If the 4Cs are

 

Multiple aspects of the 4<:. s

Significanr (Jr complete

clear, concise,

represented; the

 

:'Ipp:.lrenl; opponuniry exists

 

are missing, or have nor

disregard for the gurdance

captivating

visualization L •• clear, clean,

 

for further cnhanccmcnr.

 

been well addressed in the

present in me 4Cs, re$ulrjng

(Shaffer 4 0,)

concise. and c:tptiv:ttine..

 

 

 

visualization.

 

in :.l poor visualizarion.

 

Fonts choicer •• arc conscious

 

 

 

 

 

 

 

Linlc or no :1pp:tre:nt thought

 

and consisreru; PI'<'pct

 

Visualization shows thought

 

Visualization :tppe:tfs sloppy

(Jr given and visualization

Attractiveness

gr-.amlll:tr and spelling is

 

and planning, and most

 

and m:1}' be difficuh to

comes across as discrganiaed.

and attention to

1.15('(1. and choice of posldon,

 

:l..C;PCCtS work in barmouy.

 

understand as a coherent

i\lar he visible rhrough

 

M:.l)' exhibit minor Issues

 

whole.

Multiple issues with

numerous spelling or

design and

siec, and emphasis integrate

 

wirh spelling, alignmenr; (I(

 

spelling. four consistency

gramm .. ar issues, poor

details of craCt

clements into :.l visually

 

 

 

appealing and eng:'lging

 

sil.ing mismarchcd with

 

posirioning. or other

alignmcnr and positioning

 

whole.

 

importance.

 

discr:acring characteristics.

choices inappropriate four

 

 

 

 

 

 

 

 

 

 

usc, ere.

The

'11)e visualization is eugercd

 

There is ':'I clear message or

 

The visuahznnon $ug.,~eMs

 

visualization is

10 the audience, the slorr i.s

 

story conveyed, luu the

 

some possibilities, but does

No apJY.Irent message (II'

evident, and the conclusion

 

action or conclusion rhar

 

relevancy to the user; no

usable and

or action required is clearly

 

should be drawn is nor

 

nor lead to clariry (if

actions can nor should be

actionable

 

 

undersranding and therefore

(Duelt Rules)

apparcnt.

I (J additional

 

definitive.

May require

 

action L s not possible.

taken based on the analysis.

inrcrprerarion is needed

 

interpretation.

 

 

QuaUty,

The analysis shows a level

 

The overall conclusions (If

 

The M:.llrsi.s shows :.l trend

The analysis :tp~.rs to be

integrity, and

of quality, mlcgnt)'. and

 

the an:tl)<$is seem to be

 

or suggcsls a result, but is

poorly ccodncred. gkady

impact of the

c~lmpc:tency rbar makes the

 

sound, with Sllppotl by

 

not trustworthy because (If

compromising the inrcgrirr

findings and

viz irnpacrful, gene-rndng :'I

 

anecdotes or additional

 

errors in proccss, omission,

of some orall (If the

analysis

hie.h level of trust.

 

evidence.

 

 

(II' scope.

 

vrsualizauon.

Overall

The visualization is

 

Delivery provides a sU'(lng

 

The presentation and

The cornmunicanon and

effectiveness of

delivered in ':'I convincing

 

:.lrgument and is well

 

communication leaves

presentation results in

communication

\"':l~f thar demonscares

 

supported: mmor derails

 

concerns (J1 lingering lack of

confusion and low level of

and

confidence, compctcncy,

 

should be veered and

 

clariry. \"(fork required ro

confidence in the analysis,

presentation

and eboroughncss.

 

affirmed.

 

review and confirm.

RUBRIC for Data Viz Project

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 middle-class households to examine the current relationship between the total consumer debt of a household and its income. We estimate that 2-3% 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 middle-income households, and (2) develop rule of thumb, based on this relationship, for identifying the 2-3% 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 2-paragraph 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 3-paragraph 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
Three hundred consumers between 21 and 49 years old were randomly selected. After sampling a new wine cooler, each was asked to rate the appeal of the phrase: "Not sweet like wine coolers, not filling like beer, and more refreshing than wine or mixed drinks" as it relates to the new wine cooler. The rating was made on a scale from 1 to 5, with 5 representing "extremely appealing" and with 1 representing "not at all appealing".

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®:

  1. Estimate the probability that a randomly selected 21 to 49 year old consumer:
    • Would give the phrase a rating of 5
    • Would give the phrase a rating of 3 or higher
    • Is in the 21-24 age group
    • Is a male who gives the phrase a rating of 4
    • Is a 35 to 49 year old who gives the phrase a rating of 1
    • Based on the probabilities for the ratings of 4 and 5, which age/gender demographic would be the best target audience for the new concept? 
  2. Create a probability distribution using the data which shows how many cartons of the wine cooler were bought per customer in a month. 
    • Calculate the mean and the standard deviation of your probability distribution. 
    • Calculate the probability that exactly 3 six packs will be bought in a month.
    • Calculate the probability that between 4 and 8 six packs will be bought in a month.
    • Calculate the probability that at least 5 six packs will be bought in a month.
    • Calculate the probability that no more than 5 six packs will be bought in a month. 
  3. Create a relative frequency distribution based on the wine cooler drinking temperatures. 
    • Create 6 bins with the same interval in each. 
    • Create a histogram
  4. Considering the mean and standard deviation for the ideal drinking temperature: 
    • Calculate z values then refer to Table 6.1 - Cumulative Areas Under the Standard Normal Curve 
    • Calculate the probability of the wine cooler being less than 45 degrees.
    • Calculate the probability of the wine cooler being greater than 60 degrees.
    • Calculate the percentage of wine coolers served at the ideal temperature, between 49 and 55 degrees.
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

Embry-Riddle 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 re-routed line and clerk can serve a new guest every 2 minutes. This will result in an average wait time of:

1/(µ-ƛ) = 1/(30-24) = .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.79-14) = .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/(20-16) = .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 check-in 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 front-desk 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 quick-service 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 single-line 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 check-ins.  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 check-in 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.

You need to show all the work/steps, partial credit will be provided. Submitting just the answers (even if they are correct) does not provide for any partial credit.

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

 

8-1 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?

 

 

8-2 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?


 

8-3 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.

  1. Find the average number of moviegoers waiting in line to purchase a ticket.
  1. What percentage of the time is the cashier busy?
  1. What is the average time that a customer spends in the system?
  1. What is the average time spent waiting in line to get to the ticket window?
  1. What is the probability that there are two or more people in the system?
  1. What is the probability that there are more than four people in the system?
  1. What is the probability that there is no one in the system?
  1. What are two things Mike could to reduce the time to get a ticket?

 

 

8-4 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 two-week 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:

  1. Average number of trucks in the unloading system.
  1. Average time per truck in the system.
  1. Utilization rate for the bin area.
  1. Probability that there are more than three trucks in the system at any given time.
  1. Total daily cost to the farmers of having their trucks tied up in the unloading process.

 

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 off-season.

f.  Would it be worth the cooperative’s while to enlarge the storage area?

 

 

8-5 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 two-person crew, still acting like a single-server 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?

 

 

8-6 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.

  1. What is the average number of people waiting in line?
  1. What is the average number in the system?
  1. How long does the average person wait in line before receiving service?

 

 

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 double-spaced 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 double-spaced 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.

 




Bottle Number




Ounces




Bottle Number




Ounces




Bottle Number




Ounces




1




14.23




11




15.77




21




16.23




2




14.32




12




15.80




22




16.25




3




14.98




13




15.82




23




16.31




4




15.00




14




15.87




24




16.32




5




15.11




15




15.98




25




16.34




6




15.21




16




16.00




26




16.46




7




15.42




17




16.02




27




16.47




8




15.47




18




16.05




28




16.51




9




15.65




19




16.21




29




16.91




10




15.74




20




16.21




30




16.96



Write a two to three (2-3) page report in which you:

  1. Calculate the mean, median, and standard deviation for ounces in the bottles.
  2. Construct a 95% Confidence Interval for the ounces in the bottles.
  3. 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.
  4. Provide the following discussion based on the conclusion of your test:

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:

  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides. No citations and references are required, but if you use them, they must follow APA format. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

  • Calculate measurements of central tendency and dispersal.
  • Determine confidence intervals for data.
  • Describe the vocabulary and principles of hypothesis testing.
  • Discuss application of course content to professional contexts.
  • Use technological tools to solve problems in statistics.
  • Write clearly and concisely about statistics using proper writing mechanics.

 

 

 

 

 

 

 

 

 

 

 

 

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 double-spaced 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 one-inch 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 follow-up 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 cut-and-paste references.

            Even with cut-and-paste, 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                                    Self-assessment (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,000-80*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.

 

 

 

Computer

 

 

Profit per

Maximum

demand for

 

 

Wiring Hours

Assembly

Hours

Inspection

Hours

Model

Model ($)

product

Required

Required

Required

Plain

30

80

0.4

0.5

0.2

Fancy

40

90

0.5

0.4

0.3

 

 

Hours Available

50

50

22

 

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 bell-shaped 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 z-score less than –3 or greater than +3 is treated as a(n)

a.    Outlier (i.e. defective item).

b.   usual value.

c.    Non-defective value.

d.   z-score 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:

Raw Material Cost ($)

Probability

Production
Cost ($)

Probability

Marketing
Cost ($)

Probability

16

0.20

10

0.25

5

0.40

18

0.30

11

0.45

6

0.60

20

0.35

12

0.30

   

22

0.15

       

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

 

A

B

C

D

E

 

Jones Furniture

 

 

 

 

 

 

 

Beds

Desks

 

 

Number to make:

0

0

 

Total Profit:

Unit profit:

30

40

 

 

 

 

 

 

 

Constraints:

 

 

Used

Available

Carpentry

6

4

 

36

Varnishing

4

8

 

40

Desk demand

 

1

 

8

           

 

_____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:E10D8: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:
a.     2 and 2; b.            1 and 2; c.       4 and 3; d.       3 and 3; e.       3 and 4.; f. none of the above

 

_____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:
        Demand               Frequency
        0                           38
        1                           22
        2                           22
        3                           18

a) 0. b) 1. c) 2. d) 3, e) 1 or 2.

 

______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?

Activity

Immediate Predecessor

Time (days)

A

-

8

B

-

7

C

A, B

4

D

B

3

E

C, D

4

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 tax-deferred 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.

Decision Variable

Investment Option

Risk

Projected Annual Return

X1

Stock – EAL

High

15%

X2

Stock – BRU

Moderate

12%

X3

Stock – TAT

Low

9%

X4

Bonds – long term

 

11%

X5

Bonds – short term

 

8%

X6

Tax-deferred annuity

 

6%

 

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 tax-deferred annuity.

·         At least 25% of the funds invested in stocks are to be in the low-risk 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 Tax-deferred 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 less-than-or-equal-to constraint indicates the difference between the left-hand and right-hand 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 Lastname-Asmt41.xlsx, Lastname-Asmt42.xlsx, and Lastname-Asmt43.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 re-optimize 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 dual-objective 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 plot-1 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

X

Y

1

7

3

6

10

9

9

8

10

1

7

8

2

2

7

1

2

5

8

2

1

10

 

 

 

 

4.       Compute the correlation coefficient for the following data set

 

X

Y

 

 

1

10

 

 

5

6

 

 

7

4

 

 

3

8

 

 

10

1

 

 

2

9

 

 

4

7

 

 

6

5

 

 

9

2

 

 

8

3

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

                             

 

5.       Compute the correlation coefficient for the following data set

 

X

Y

 

 

8

10

 

 

3

3

 

 

2

6

 

 

6

6

 

 

8

2

 

 

8

4

 

 

7

2

 

 

1

6

 

 

1

1

 

 

2

7

 

 

6

7

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

                             

 

6.       Compute the correlation coefficient for the following data set

7.       Compute the coefficient of determination for the following data set

 

 

X

Y

 

 

4

7

 

 

1

3

 

 

3

6

 

 

5

8

 

 

2

6

 

 

1

2

 

 

2

3

 

 

1

10

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

                             

 

 

 

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