Question

In: Statistics and Probability

Using the data below, what percentage of data would you predict would be between 25 and...

Using the data below, what percentage of data would you predict would be between 25 and 50 and what percentage would you predict would be more than 50 miles? Then determine the percentage of data points in the dataset that fall within each of these ranges. How do each of these compare with your prediction and why is there a difference?

Predicted percentage between 25 and 50 miles:

Actual percentage between 25 and 50 miles:

Predicted percentage of more than 50 miles:

The actual percentage of more than 50 miles:

Comparison:

Why?:

Drive

36

20

88

6

71

42

76

63

36

63

38

28

55

33

40

80

86

83

4

39

25

25

54

54

81

73

29

76

78

77

42

36

71

94

6

Solutions

Expert Solution

From the given data

i) Predicted percentage between 25 and 50 miles is 32.36%

since

ii) Actual percentage between 25 and 50 miles:

The number of observations lies between 25 and 50 miles is 13. Its probability is 13/35 = 0.3714 = 37.14%

iii) Predicted percentage of more than 50 miles is 52.56%

iv) The actual percentage of more than 50 miles:

The number of observations more than 50 miles is 18. Its probability is 18/35 = 0.5143 = 51.43%

If the distributions perfectly normal distribution, then the predict percentage and actual percentage give exact(same) percentages.

In our example, percentages are nearly closed so out distribtuion is closed to normal distribution


Related Solutions

What percentage of data would you predict would be between 25 and 50 and what percentage...
What percentage of data would you predict would be between 25 and 50 and what percentage would you predict would be more than 50 miles? Use the Week 4 spreadsheet again to find the percentage of the data set we expect to have values between 25 and 50 as well as for more than 50. Now determine the percentage of data points in the dataset that fall within each of these ranges, using same strategy as above for counting data...
What percentage of data would you predict would be between 40 and 70 and what percentage...
What percentage of data would you predict would be between 40 and 70 and what percentage would you predict would be more than 70 miles? Subtract the probabilities found through =NORM.DIST(70, mean, stdev, TRUE) and =NORM.DIST(40, mean, stdev, TRUE) for the “between” probability. To get the probability of over 70, use the same =NORM.DIST(70, mean, stdev, TRUE) and then subtract the result from 1 to get “more than”. Now determine the percentage of data points in the dataset that fall...
Using the existing regression equation, what would you predict the revenue of a team to be...
Using the existing regression equation, what would you predict the revenue of a team to be if the coach’s salary is .5 million and the winning percentage is 30 percent? Select one: a. 12 Million b. 14.8 Million c. 15.0 Million d. 14.2 Million e. Cannot be determined from the data. School Revenue %Wins Salary Alabama 6.5 61 1.00 Arizona 16.6 63 0.70 Arkansas 11.1 72 0.80 Boston College 3.4 80 0.53 California 6.0 68 0.85 Cincinnati 5.7 61 0.18...
Excel Assignment (Percentage-of-completion) Required: 1- Using the data provided below you are to input formulas in...
Excel Assignment (Percentage-of-completion) Required: 1- Using the data provided below you are to input formulas in the area designated below to calculate: % complete, revenue to be recognized in each year, and gross profit to be recognized in each year. (10 points) Hint: I suggest you use formulas with an IF function regarding the gross profit section of your speadsheet because your spreadsheet should be able to calculate correct answers whether a contract generates a profit or loss. 2- Using...
Using data from the table below, estimate the percentage of chlorocyclohexane molecules that have their substituents...
Using data from the table below, estimate the percentage of chlorocyclohexane molecules that have their substituents in an axial orientation at room temperature. Table 4.1 - http://imgur.com/ZLsHz5S,9ose7I0 Figure 4.12 - http://imgur.com/ZLsHz5S,9ose7I0#1
Using the International Stock Market data in below, conduct a stepwise multiple regression procedure to predict...
Using the International Stock Market data in below, conduct a stepwise multiple regression procedure to predict DJIA by the Nasdaq, the S&P 500, the Nikkei, the Hang Seng, the FTSE 100, and the IPC. Develop a correlation matrix and discuss the correlations among all variables. ( please show step by step about doing correlation in excel and discuss) Perform a stepwise regression procedure (use α = 0.1) to select predictor variables for the model. Summarize the results (with t-values and...
Use the following data to predict the wage you would have to pay to hire a...
Use the following data to predict the wage you would have to pay to hire a particular individual. a. Specify a regression equation b. Estimate a regression equation to explain wages c. Explain the t-stats, f-stats, and the R Squared. What information do they give ? d. You have a nonwhite female with 20 years in the industry and an MBA. How much will you have to pay to hire her? What if she was a white male? e. Does...
25. In Data Mining, ___ is a set of input variables used to predict an observation's...
25. In Data Mining, ___ is a set of input variables used to predict an observation's outcome class or continuous outcome value. 26. During each iteration of cluster analysis, the distances between new clusters are determined until any two clusters are sufficiently close to be linked using an algorithm called ___. 27. In the CRISP-DM process for data mining, which phase is the cleaning of the data so it is ready for modeling tools?
In which case below would you predict males to have the largest testes size? a. Mates...
In which case below would you predict males to have the largest testes size? a. Mates are strictly monogamous. b. Females freely mate with multiple males. c. Males closely defend groups of females from other males. d. Males are able to “seal off” the female’s reproductive tract after mating.
Using the following to create a vertical analysis, what percentage would be reported for Property, Plant...
Using the following to create a vertical analysis, what percentage would be reported for Property, Plant & Equipment? 2015 2014 Common Stock $ 300,000 $220,000 Current Assets $ 100,000 $110000 Current Liabilities $ 50,000 $90,000 Intangible Assets $ 120,000 $130,000 Investments $ 200,000 $200,000 Long-term Liabilities $ 250,000 $275,000 Other Assets $ 80,000 $75,000 Property, Plant & Equipment $ 300,000 $250,000 Retained Earnings $ 200,000 $ 180,000
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT