In the smoking/drinking example in this section, we used the function COUNTIFS function (new to Excel 2007) to find the counts of the joint categories. Without using this function (or pivot tables), devise another way to get the counts. The raw data are in the file Smoking Drinking.xlsx.
Answer to relevant QuestionsRecall that the file Baseball Salaries 2009 Extra.xlsx contains data on 818 Major League Baseball (MLB) players during the 2009 season. Use StatTools to find the mean, median, standard deviation, and first and third ...The file S02_07.xlsx includes data on 204 employees at the (fictional) company Beta Technologies. a. Create a table of correlations between the variables Age, Prior Experience, Beta Experience, Education, and Annual Salary. ...The file S02_11.xlsx contains data on 148 houses that were recently sold in a (fictional) suburban community. The data set includes the selling price of each house, along with its appraised value, square footage, number of ...Solve problem 4 with pivot tables and create corresponding pivot charts. Express the counts as percentage of row. What do these percentages indicate about this particular data set? Then repeat, expressing the counts as ...Using the Elecmart Sales file from this section, experiment with slicers as follows.a. Create a pivot table that shows the average of TotalCost, broken down by Region in the row area and Time in the column area. Then insert ...
Post your question