Assuming .05 as your alpha value, make up a problem similar to this one. Make up 36 gas prices for your example. Use price values in your list that some you made up and be sure they are similar to the prices you have had in your area. List the values in your post.Instructions for your response. In your response, copy the original problem, describe what you did and give the mean, standard deviation and confidence interval. Then attach the excel spreadsheet below so students and the professor can check your work.Example below:First find the mean. List all 36 gas prices in cells A1 to A36 in your excel spreadsheet.On a different cell type in =average(A1:A36) and the hit enter to find the averageAssume your answer is 2.65On a different cell type in =stdev.s(A1:A36) or =stdevA(A1:A36) and enter to find the standard deviationAssume your answer is .43Then type this in an excel cell =confidence.norm(.05,.43,36) and hit enter. This is the E valueSo take the mean of 2.65 and you have (2.65-E, 2.65+E) for your confidence intervalFormula you used above for the confidence interval:The formula is E= zsubc * sigma / sqrt nWhere the left hand endpoint is xbar - E and the right hand endpoint is xbar + EJust a review of your instructions:You will make up a problem with alpha = .05 and give the values for the problem. This is your main post.Instructions: Your initial post should be at least 250 words.

stats homework really easy need help with itneed to answer them in a hour plsChapter 4Choosing an Appropriate Measure of Central Tendency ExerciseIn this exercise, you will work through different scenarios to determine which measure of central tendency is most appropriate. 1. Depending on the scale of measurement, indicate the most appropriate measure for central tendency for each of the following dependent variables.(a) The time (in seconds) it takes rat subjects to attain reinforcement.(b) The preference ranking for five different ringtones. (c) The number of freshman, sophomore, junior, and senior students. (d) The number of children liking cereals containing one of three prizes.(e) The income of individuals with no health insurance.(f) The age (in years) that participants tried their first cigarette. (g) The order in which participants complete an endurance task.(h) The number of children in single- or two-parent homes.(i) The ranking of the effectiveness of four types of learning exercises.2. Given the following values of the mean and median, state the likely shape of the distribution and which measure should be used to summarize it. (a) mean = 4, median = 4 _______________(b) mean = 12, median = 2 _______________(c) mean = 8, median = 18 _______________(d) mean = 6, median = 14 _______________(e) mean = 10, median = 3 _______________(f) mean = 8, median = 8 _______________3. Draw a negatively skewed, positively skewed, and normal distribution. Mark the location of the mean, median, and mode for each distribution.