Place order now

Discussion: Help on 4 stats problems

Discussion: Help on 4 stats problems

Discussion: Help on 4 stats problems

ORDER NOW FOR CUSTOMIZED AND ORIGINAL ESSAY PAPERS 

Please answer the following problems, there is an excel sheet attached for the problems 6,8, and 10. please use the excel I have attached to write the answers to the problems. no handwritten assignments please have it typed up and copied on to a pdf after you finished. Thank you!

1. The following data represents the state’s ranking (1=above average, 2 = average, 3= below average) for six local school districts (i.e., the population).

District Rating

A 1

B 3

C 2

D 2

E 1

F 2

E 2943

6. Based on the sales data from problem 1, find the following.

a) 2-period moving average and MSE

b) 4-period moving average and MSE

c) Forecast for periods t =13 and t =14. Which forecast is preferred, based on MSE?

d) Plot the sales data over time on the same plot as the 2 and 4-period moving averages with their forecasts. Comment on the plotted results.

8. Based on the sales data from problem 1, find the following.

a) Linear trend equation

b) Forecast for periods t =13 and t =14.

c) Plot the sales data over time on the same plot as the linear trend. Comment on the plotted results.

10. Monthly expenses for an advertising agency were obtained for the previous year. The sample of 12 expenses showed a mean of $196,000, with a standard deviation of $45,000. The office manager is budgeting for monthly expenses, and would like to know if it is reasonable to expect expenses to be below $250,000. Construct a 95% confidence interval to justify if $250,000 is reasonable.

 

t 1 2 3 4 5 6 7 8 9 10 11 12 Sales 2245 2450 3245 3750 3450 3150 2970 2560 2225 2100 2350 2275 t 1 2 3 4 5 6 7 8 9 10 11 12 Sales 2245 2450 3245 3750 3450 3150 2970 2560 2225 2100 2350 2275 year Month 1 1 Usage 932.605 1 2 794.779 1 3 579.243 1 4 313.171 1 5 197.513 1 6 134.038 1 7 111.307 1 8 107.074 1 9 117.299 1 10 201.580 1 11 446.801 1 12 847.001 2 1 969.921 2 2 769.244 2 3 600.851 2 4 347.059 2 5 207.533 2 6 134.708 2 7 111.305 2 8 109.223 2 9 121.903 2 10 227.357 2 11 428.615 2 12 685.976 3 1 801.268 3 2 666.582 3 3 406.764 3 4 280.678 3 5 162.893 3 6 123.596 3 7 108.500 3 8 106.218 3 9 119.129 3 10 241.974 3 11 485.522 3 12 676.616
You must proofread your paper. But do not strictly rely on your computer’s spell-checker and grammar-checker; failure to do so indicates a lack of effort on your part and you can expect your grade to suffer accordingly. Papers with numerous misspelled words and grammatical mistakes will be penalized. Read over your paper – in silence and then aloud – before handing it in and make corrections as necessary. Often it is advantageous to have a friend proofread your paper for obvious errors. Handwritten corrections are preferable to uncorrected mistakes.

Use a standard 10 to 12 point (10 to 12 characters per inch) typeface. Smaller or compressed type and papers with small margins or single-spacing are hard to read. It is better to let your essay run over the recommended number of pages than to try to compress it into fewer pages.

Likewise, large type, large margins, large indentations, triple-spacing, increased leading (space between lines), increased kerning (space between letters), and any other such attempts at “padding” to increase the length of a paper are unacceptable, wasteful of trees, and will not fool your professor.

The paper must be neatly formatted, double-spaced with a one-inch margin on the top, bottom, and sides of each page. When submitting hard copy, be sure to use white paper and print out using dark ink. If it is hard to read your essay, it will also be hard to follow your argument.