Question: 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.

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.

Step by Step Solution

★★★★★

3.44 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

415-M-S-D-A (557).xlsx

300 KBs Excel File

Students Have Also Explored These Related Statistics Questions!

Data in the Excel file points per game. xlsx show the number of wins eight teams had during a recent NFL season. Also in this file are the average points each team scored per game during the season....

The Excel file titled states. xlsx contains the median income in 2011 for all 50 states and the District of Columbia. a. Use Excel to draw a simple random sample consisting of four states, and then...

The Excel file MLB payroll. xlsx provides the payroll and number of wins for all the Major League Baseball teams during the 2012 season. Construct a scatter plot using these data. Describe the...

Project Purpose As a college student, you are making an investment in your education. This project will look at how that investment could pay off after graduation and working a job in your desired...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

The best definition for nonparametric statistics I can think of is when data does not fit inside the normal parameters of a normal distribution, it calls for the use of this statistical method....

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in...

(1) The Quality of Financial Information Referencing this week?s readings and lecture, describe the quality issues related to reporting revenue. What is the importance of understanding various...

This case will use an Excel Workbook as a Tutorial Tool (with learning content incorprated into each worksheet). Within the Workbook there will be multiple worksheets that the student will need to...

Find an equation of the tangent line at the indicated point on the graph of the function. w = g(z) = 9+7-z, (z, w) = (6, 10) w=2+1 + 13 w=2-13 -=-12-13 W= 2+13 W

Select ALL peptides that would be expected to adsorb to a strong-cation exchange column at pH 5.0: ADDSYEEGGL AKKSYTTGGL AEESYRRGGL AGGSYLLGGL O AKKSYHHGGL

2. LO.1 The alternative minimum tax applies to an S corporation. Discuss the validity of this statement.

Why is it more difficult to value privately held companies than publicly traded firms?

In the RedBrand model in the file RedBrand Logistics Shrinkage Finished.xlsx, change the assumptions. Now instead of assuming that there is some shrinkage at the warehouses, assume that there is...

In the employee scheduling example, suppose that each full-time employee works eight hours per day. Thus, Monday's requirement of 17 workers can be viewed as a requirement of 8(17) = 136 hours. The...

In the employee scheduling example, suppose the employees want more flexibility in their schedules. They want to be allowed to work five consecutive days followed by two days off or to work three...

Who should lead a security team? Should the approach to security be more managerial or technical?

The real risk - free rate ( r * ) is 2 . 8 % and is expected to remain constant. Inflation is expected to be 5 % per year for each of the next five years and 4 % thereafter. The maturity risk premium...

Generally, the marketable securities account includes securities that are traded in the money markets. Group of answer choices True False...