Hans Langenscheidt is a German historian studying various demographic characteristics German immigrants and their influence on colonial America in eighteenth century. Although accurate records are found rarely, some records showed that the cost of an adult fare (one freight) from Rotterdam to New York was approximately $2000 in today's currency. Children between the ages of 4 and 13 were charged at half the adult rate (one-half freight).Children under 4 were not charged. He was also able to find a partial list of passengers for a ship called NeuWelt. This list contains the names of the head of families, a list of family members traveling with them, their parish of origin, and the number of freights each family purchased. Unfortunately, some information is missing for some families on this list. Langenscheidt believes that the demographic parameters of the passenger list are likely to be similar to those of the other numerous voyages taken from Germany to America during the mid-eighteenth century.Assuming that he is correct, he believes that it is appropriate to discrete probability distribution for a number of demographic variables for this population of German immigrants.His distributions are presented in the Excel 1 file attached in the Final Project learning object.

Based on this background information and the distributions data on the Excel file, answer the following questions. In your answers provide any supporting statistical work (graphs, probability calculations, etc.) and be thorough in your explanations. Summarize all your findings in a report.

1. Using the information provided, describe each probability distribution in the given Excel file. Use histograms and numerical summaries such as the mean and standard deviation and their interpretations in your explanations.

2.Estimate the average cost of the travel for a family in U.S. dollars, using the mean number of freights purchased per family.

3.Is it appropriate to estimate the average cost of the voyage from the mean family size?Why or why not?

4.Langenscheidt came across a partial list of passengers from another ship.This list included information for six families only.Of these six, five families purchased more than four freights.Using the information contained in the appropriate probability distribution for the NeuWelt, calculate the probability that at least five of six German immigrant families purchased more than four freights.Does it seem likely that these families came from a population similar to that of the Germans on board the NeuWelt?Explain.

5.What additional points can you deduce from this analysis? Discuss any assumptions made throughout your analysis.

AutoSave On . MATH807-FinalProject-PART II Data (2) - Last Modified: 6h ago Search A Jacqueline Gray JG X File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Calibri 11 ~ A" A = [ Copy de Wrap Text General X AutoSum Fill AY O 4 Paste Format Painter BIU~ ~ DAY EE Z E Merge & Center v $ ~ % 9 70 20 Conditional Format as Cell Insert Delete Format Clear Sort & Find & Ideas Formatting * Table Styles Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas C13 X V fix A B C D E F G H K M N O P Q R S Probability Distribution of the Probablylity Distribution of the Probability Distribution of the Known Numbers of Freights Known Numbers of People in a Number of Families per Parish of Purchased by the German Family for the Germans on Board German Immigrants on Board the Families on Board the ship the ship NueWelt in mid-18th ship NueWelt in mid-18th century NueWelt in mid-18th century century Number of Families per Parish Probablelity Number of Freights Probability Number in Family Probability 1 0.706 1.0 0.075 IN 1 0.322 ).176 1.5 .025 ).186 0.000 2.0 0.425 .136 4 0.059 2.5 0.150 5 0. 102 0.000 3.0 0.125 6 0.051 0.059 3.5 0.100 0.136 4.0 0.050 0.034 5.0 0.025 0.017 6.0 0.025 0.016 18 19 20 21 22 23 Sheet1 + + 100% Type here to search X 3:41 PM 8/6/2020 E