Excel and the marketing pricing study data

Assignment Help Engineering Mathematics

Reference no: EM13823164

Utilizing Excel and the Marketing Pricing Study Data (MPS.CSV), create a two-way contingency table of Group Name to Internet Usage (Q18). Conduct a chi-square Test of Independence (use percentages of total option). Answer the following question:

a. what are the hypotheses involved?

b. Which cell has contributes the most to the chi-square statistic?

c. What is the overall chi square statistic?

d. What is the P value?

e. At a 5% level of significance what would be the outcome?

f. The chi square test assumes that Q18 has what type of scaling? Is this a good assumption?

Reference no: EM13823164

Questions Cloud

Describe four methods of learning and listening : Describe four methods of learning and listening. How does a person learn (auditory, visual, etc.) if he or she has a preferred method? How can the person adjust to learning in ways not in his or her preferred method

Find the center line and control limits for the chart : Question 1: A process is to be monitored with standard values m = 10 and s = 2.5. The sample size is n = 2. (a) Find the center line and control limits for the chart.

Prepare the journal entries to record the issuance : Hot Springs Marine borrowed $20 million cash on December 1, 2011, to provide working capital for year-end inventory. Hot Springs Marine issued a 4-month, 9% promissory note to Third Bank under a prearranged short-term line of credit. Prepare the jour..

Calculate the growth rate of these dividends : Lisa owns stock in a company which has paid the annual dividends shown in below table calculate the growth rate of these dividends. Calculate the growth rate of these dividends. Calculate the estimated dividend for 2004.

Excel and the marketing pricing study data : Utilizing Excel and the Marketing Pricing Study Data (MPS.CSV), create a two-way contingency table of Group Name to Internet Usage (Q18). Conduct a chi-square Test of Independence (use percentages of total option). Answer the following question:

What is the amount of the deposits in transit : The Cash account in the ledger of Clear Windows shows a balance of $12,951 at September 30. The bank statement, however, shows a balance of $16,453 at the same date. What is the adjusted cash balance in the September 30 bank reconciliation? What is t..

Assessing the accuracy of a source : Which of the following questions is recommended for use in assessing the accuracy of a source

Considering investment in a project with a beta coefficient : Mrs. Smith is considering investment in a project with a beta coefficient of 1.35. What would you recommend if this investment has an 11.5% rate of return, risk free rate is 2.5%, and the rate of return on the market portfolio of assets is 8.5%.

Discuss the methods of controlling thermal conditions : Discuss the methods of controlling thermal conditions. Include engineering controls, administrative controls, and work practices.

User Account

All Pages