Statistics Assignment on Excel

This Statistics Assignment is an excel-based statistics homework on Microsoft Excel. It is quite similar to a case study as well. It’s based on determining descriptive statistics, chi-square and t-test according to given dataset (excel file). If you need similar help, register & post your assignment to get instant help from our Excel experts!

Assignment Type: Excel Assignment

Assignment Category: Statistics Assignment Help

Platform: Microsoft Excel Assignment

University: Unknown

Template: Unknown

Assignment Size: 2 hour

Attached File(s); None.

Assignment Details for the Statistics Homework on Excel

Question 1

We want to study the waiting line at a local ATM. We have collected data for 16 hours (i.e., two hours each day, from 12 noon to 2 p.m., Monday thru Thursday for two weeks), each observation representing the number of new customers arrive at the ATM for the time interval of five (5) minutes. The Excel data file “ATM Data” is given in the course website under the Assignment heading. Using the data complete the following tasks on Excel spreadsheet. Note: You should attach Excel worksheet printouts. (i) Summarize the data you collected using relevant descriptive statistics. (ii) Create a histogram of the data. (iii) Perform a chi-square goodness of fit test to investigate whether the Poisson distribution provides a reasonable fit to the data. (iv) Based on your findings in (iii), what information would you provide the manager of the bank that operates the ATM with?

Question 2

Kristy is interested in investigating whether husbands and wives who are having infertility problems feel equally anxious. She obtains the cooperation of 24 infertile couples. She then administers the Infertility Anxiety Measure (IAM) to both the husbands and the wives. The Excel data file given contains 24 cases, one for each husband-wife pair, and two variables, the IAM scores for the husbands and the IAM scores for the wives. Using a=0.05, conduct an appropriate t-test on these data. On your output, identify the following: (a) mean IAM score for husbands; (b) mean IAM score for wives; and (c) p value. Be clear about your conclusions and reasons.

Legal Note for the Excel Assignment about Statistics

The assignment file and details given on this page is just an example file for Statistics Assignment/Homework on Excel. If any individual/institution believe publication of this assignment is offensive; please contact with us using Contact Form and we will get back to you in shortest possible notice.

Pure Assignment has established in Turkey. Pure Assignment is only charged of Turkish law and all matters discussed in Terms of Use and the other subtitles must be considered according to Turkish Law. According to related law (law number 5651) published in official paper;

MADDE 5 (Article number: 5)–

(1) Yer sağlayıcı, yer sağladığı içeriği kontrol etmek veya hukuka aykırı bir faaliyetin söz konusu olup olmadığını araştırmakla yükümlü değildir.

(1) The site provider is not obliged to check the content it provides or to investigate whether there is an illegal activity. (Translated by Google Translate)

(2) Yer sağlayıcı, yer sağladığı hukuka aykırı içerikten, ceza sorumluluğu ile ilgili hükümler saklı kalmak kaydıyla, bu Kanunun 8 inci ve 9 uncu maddelerine göre haberdar edilmesi halinde ve teknik olarak imkân bulunduğu ölçüde hukuka aykırı içeriği yayından kaldırmakla yükümlüdür.

(2) The site provider is obliged to remove the illegal content from the publication; if it is informed in accordance with the 8th and 9th articles of this Law. And to the extent technically possible, provided that the provisions regarding the criminal liability are reserved for the illegal content it provides. (Translated by Google Translate)

Pure assignment offers the Site and Site Services for clients to be able to share any freelance job to let them find the help from the right expert they need with their business or assignments; papers and projects; either for business purpose or educational purpose. Pure assignment aims to get clients and freelancers together to be able to help them each other. In this case, Pure assignment works as a service provider as mentioned in law (law number 5651).