Project: Conduct Quantitative Analysis ( Need Corrections)

Criterion Feedback

2 Mar: Answers and essay were sloppy with no attempt at editing, spell checking, are grammar checking being accomplished.

Criterion Feedback

2 Mar: Did not identify a pattern of interest. Instead, you regurgitated a single data point from steps 1 - 8 of the project.

Criterion Feedback

2 Mar: Did not employ the requires calculations

Criterion Feedback

2 Mar: No analysis of the data was accomplished. See comments in the attached. Issues with the essay as well as incomplete or incorrect answers for Q2, Q3 and Q4.

Criterion Feedback

2 Mar: Your histogram is not correct and you did not create the projected sales following the instructions in Question 2. For the histogram, your bins for up to 20000 and 30000 should have been zero. There are no employees making 0 - 20000 or making 20001 to 30000. As such, these bins are zero. See your histogram sheet where I started you off with the correct information. For the projected sales, select the "Sales Summary (Provided)" chart and simply click on Forecast Sheet on the data tab. Excel will calculate your forecast for you. Additionally, your formulas for the role table in section 2 are incorrect and you chose not to complete section 3. You should know that there are 372 employees. If you add up every instance of every job title...there should be 372 instead of the 288 you came up with in section 2. There are two problems with your formulas. First, you did not read the section in the steps concerning absolute references. Your array is C11:C382 as documented in cell C389. Since you did not use an absolute reference, you have different arrays in use. For example, the array in cell C406 is C11:C410 which also created a circular reference in that your formula is including itself in the array. Your array in C389 should have included the dollar sign to make it an absolute reference as follows: C$11:C$382. The other issue is that you manually entered incorrect values for the roles. Instead of "Acctg/Fin", you entered "ACCT/FIN". Of course your count is going to be zero. What you should have used for the formula is =COUNTIF(C$11:C$382,B389). This tells excel to identify the value of cell B389 and count every instance of that value being included in the array starting in cell C$11 and ending in cell C$382.