Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3 1 S c Yes 1 C A 5 Tel M Ne 1 5 5 5 A C D C ON 1 10 11 12

image text in transcribed
image text in transcribed
3 1 S c Yes 1 C A 5 Tel M Ne 1 5 5 5 A C D C ON 1 10 11 12 13 M 5 3 M Ne Ne NO is No YE NO A A 15 2 1 1 M 17 18 19 20 21 22 23 24 1 A 3 C C C A D A No ya Yes Yes NO Yes ve NO Yes 5 5 1 1 26 27 28 M 5 M 5 5 w 10 NO Yes Yes Yes C A A C A A C C A A 32 33 34 V SE SE 1 se M D No NO Yes ON D A A c 5 5 3 M M Yes Ne 1 39 39 40 41 42 43 44 -45 45 47 48 49 50 51 52 53 54 55 56 57 W 5 1 N 1 Yes Ne is Yes Yes Ne A A D C C C D A D C A c M 3 No NO No A A A C 5. 1 1 1 59 60 61 M 5 No A 64 1 1 NO NO c C The accompanying data set contains three variables, x1, x2, and x3. Dricture Click here for the Excel Date File a. The variable x, contains 3 categories: S, M, and L. Convert the category names into category scores (.e.5 =1, M = 2, and L = 3). What is the average score for the variable xy? (Round your answer to two decimal places.) Average score of my b. Transform x2 into an appropriate number of dummy variables. How many dummy variables should be created? Number of dummy variables to be created c. The variable xy contains four categories: A, B, C, and D. Reduce the number of categories by combining the two least frequent categories into a new category E. How many observations are in the E category? Number of observations in the category

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Excel For Accountants Tips, Tricks & Techniques

Authors: Conrad Carlberg

1st Edition

1932925015, 9781932925012

More Books

Students also viewed these Accounting questions

Question

1. Describe the Good Lives Model of offender rehabilitation

Answered: 1 week ago

Question

Explain the focus of safety programs.

Answered: 1 week ago

Question

Describe the consequences of musculoskeletal disorders.

Answered: 1 week ago