Question

I am working with data analysis and with a survey. I am cleaning up the following...

I am working with data analysis and with a survey. I am cleaning up the following variables, how do I handle the negative 1's?

Do I delete them get the mean and then replace the -1s with the mean?

Do I not delete the -1s, get the mean and then replace -1s with the mean (that included the -1s).

Do I delete them completely?

My professor said something about either deleting them altogether or if neg 1s were under 10% to replace the negative 1s with the mean--didn't really understand this.

Research question is:

Is there a correlation between how often someone uses the internet and

their concern for privacy. (consumers have lost control over how personal information is collected and used by companies) QpRi2;Q9a

this is part of the dataset:

Use_Internet Concern_Privacy
-1 -1
1 2
-1 1
1 1
1 2
-1 1
1 1
2 1
1 2
1 1

Homework Answers

Answer #1

The professor meant that you have two ways to go about it which are:

1. If there are a significant number of negative ones (more than 10%), it would be better if you delete those data points, otherwise if you do imputations on these data points, the results would get affected significantly.

2. If there are not a significant number of negative ones (less than 10%), we can do the mean imputation on these data points. So, take the mean of the column (do not include the negative ones, we never include the bad values) and replace the negative ones with the mean computed for the corresponding column. Example- If you are replacing the -1 in Use_Internet, find the mean value of that column without including the negative ones and replace all the data points having -1 with the mean value. Hence, in this way the data will be cleaned up.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Hello, I am working on a internet marketing/business assignment but I am unsure of how to...
Hello, I am working on a internet marketing/business assignment but I am unsure of how to solve it. Please help me. The assignment details are below. Consider this scenario: Your friend starts a website, nothingbutflags.com, which is not making money. Your friend asks you to help generate more traffic. You ask your friend how much traffic the website had last month? And your friend replies and says only 500 visits. You also ask how many flags did you sell? Your...
Can someone please clarify for me the following... I am very confused in chemistry when it...
Can someone please clarify for me the following... I am very confused in chemistry when it comes to orbitals and what exactly they mean and represent. Like let's take a random element.. for example Fe. Iron has an electron configuration of 1s22s22p63s23p64s23d6, but what exactly does that mean? Please answer the following to help me understand: 1. When I read 1s22s22p63s23p64s23d6, does this represent a single electron in Fe or does it represent all of them at once? 2. If...
I am having a hard time with working through Weighted Average Cost of Capital (WACC) on...
I am having a hard time with working through Weighted Average Cost of Capital (WACC) on a project and was curious if anyone could help me better understand it to get through my work. (I am also doing this with the company's income statement and balance sheet if that makes a difference). I need to find: 1. the firm's before-tax and after-tax component cost of debt. 2. estimate the firms component cost of preferred stock 3. and use CAPM, DCF...
Identify the sender's communication ego state: A. CP - Critical ParentB. SP - Sympathetic Parent C....
Identify the sender's communication ego state: A. CP - Critical ParentB. SP - Sympathetic Parent C. NC - Natural Child D. AC - Adapted Child E. A - Adult 1A) 1. "A good boss wouldn't make me do it" 2. "I'm always willing to help you out, Ted." 3. "I'm not cleaning that up." 4. "You're not being serious, are you?" 5. "Ill get right on it." 2A) 1. It's not my fault. I didn't clean it personally." 2. I'm...
Question: I get a Segmentation fault error sometimes when I addElementBack or print. Am I using...
Question: I get a Segmentation fault error sometimes when I addElementBack or print. Am I using pointers correctly and deleting memory properly? #ifndef DYNAMICARRAY_H #define DYNAMICARRAY_H #include <cstdlib> #include <iostream> using namespace std; // Node class class Node { int data; Node* next; Node* prev; public: Node(); Node(int); void SetData(int newData) { data = newData; }; void SetNext(Node* newNext) { next = newNext; }; void SetPrev(Node* newPrev) { prev = newPrev; }; int getData() { return data; }; Node* getNext()...
1. What are the requirements for successful price discrimination? Does this type of dry cleaning qualify?...
1. What are the requirements for successful price discrimination? Does this type of dry cleaning qualify? 2. What are other examples of price discrimination? 3. The effectiveness of price discrimination is a different question than whether businesses should be able to discriminate by price. Is this an issue that deserves regulation, or is it best left to the market? Why Women Pay More From dry cleaning to haircuts, women often pay more than men due to gender pricing. Find out...
Exercise 12.1: Empowerment Profile Step 1 Complete the following questionnaire. For each of the following items,...
Exercise 12.1: Empowerment Profile Step 1 Complete the following questionnaire. For each of the following items, select the alternative with which you feel more comfortable. While for some items you may feel that both (a) and (b) describe you or neither is ever applicable, you should select the alternative that better describes you most of the time. When I have to give a talk or write a paper, I . . . ________ Base the content of my talk or...
Reproduction and Pregnancy- Part 1 “I can’t believe it has come to this! Airing our dirty...
Reproduction and Pregnancy- Part 1 “I can’t believe it has come to this! Airing our dirty laundry on national television. I never thought Xavier would let things get so out of hand.” It was late and Andrea was so upset she couldn’t sleep. She tried studying for the upcoming exam, but she couldn’t concentrate. She decided to get an early start on packing. She was so angry with Xavier. How could he have left her pregnant and alone, she thought,...
I did already posted this question before, I did get the answer but i am not...
I did already posted this question before, I did get the answer but i am not satisfied with the answer i did the code as a solution not the description as my solution, so i am reposting this question again. Please send me the code as my solution not the description In this project, build a simple Unix shell. The shell is the heart of the command-line interface, and thus is central to the Unix/C programming environment. Mastering use of...
I am unsure of what is unclear. The instructions are: 1. Set up a worksheet for...
I am unsure of what is unclear. The instructions are: 1. Set up a worksheet for the solvency ratios--current ratio and the quick ratio. 2. Compute these ratios for Doctors Smith and Brown. To do so, you will need one additional piece of information that is not present on the doctors’ statements: their maximum annual debt service is $22,200. Practice Exercise 11–II: Solvency Ratios Refer to Doctors Smith and Brown’s financial statements presented in the preceding Chapter 10. Required 1....