Document Preview:
Your Name Course NumberDateTask 1 Question 1 Business name Pizza x1 Baker/donuts x2 Shoes stores x3 Gift shop x4 Pet stores x5 MEAN 83 92.09090909 41.5 87 51.625 MODE 35 #N/A #N/A 100 30 MEDIAN 80 87 70 97.5 49 RANGE 105 120 90 115 90 VARIANCE 1165.167 1512.619 983.7889 1289.111 729.3462 STANDAR DEVIATION 34.7429 33.64562 30.23245 40.16306 27.00641 2) Frequency and Relative frequency table x1 x2 x3 x4 x5 range freq REL Freq freq Rel freq freq rel freq freq rel freq freq rel freq 30 0 0 0 0 0 0 0 0 6 0.4 40 2 0.25 1 0.142857 1 0.142857 1 0.25 1 0.066667 50 1 0.125 1 0.142857 3 0.428571 2 0.5 2 0.133333 60 1 that the variable is significant. Doing the same for x4 which has a t value of 8.107. Its p value is also 4.7 E-08. This values lead to rejection of the null hypothesis. It leads to the conclusion that the variable cost of advertising is significant in determining the level of sales. The significance of the remaining two variables was also determined using the same criteria. They were found to be significant.in this second regression all the variables were significant in explaining the outcome of the dependent variable. The inventory levels were not significant it was therefore dropped from the model. 8) Sales = -39.46 + 20.4439 * x2 + 16.966 * x4 + 15.673 * x5 – 4.0433 * x6 Solution Sales = -39.46 + 1000 * 20.44389 + 5000 * 16.996 + 5000 * 15.673 - 2 * 4.0433 =187 741.3434 * 1000 =183 741 343.40 USD [...]
Order Description:
Hi Team, I have Group Assignment of Statistics for Business Decisions, HI6007 which I have attached below for your references. Please note that the assignment has both Ms-Excel and word part. I request the writer to carefully read the instructions and do the assignment accordingly. Please make sure the assignment is adhered to the instruction from our professor. Moreover, I request you to see in the assignment question where in we need to do the calculations in Ms-Excel and paste it in accordance with the guidelines given in the assignment instruction. There are two files in the assignment one is assignment Question and another is Numerical data information for related questions of assignment. Ms-Excel advice is the instruction of how you need to calculate and how you need to present the calculations. All the instructions are given in the attachments. I request the writer to read it very carefully so that no any single item of the assignment is missed.
Subject Area: Statistics
Document Type: Dissertation Proposal
