How do you run an ANOVA test when some of the values are non-numeric? I have...

How do you run an ANOVA test when some of the values are non-numeric?

I have a large excel database, over 100,000 cells worth of data. For the assignment, I need to see if there is a relation between the type of distribution channel (non-numeric) and the average amount of money spent (numeric). I HAVE to use ANOVA to solve this but I am not sure how. There are 11 different distribution channels and 100,000 different values for the amount of money spent. I tried using the excel function but it said I had to have all numeric cells..maybe I did something wrong?

Expert Solution

The research question is: Is there a relation between the type of distribution channel (non-numeric) and the average amount of money spent (numeric) ?

For answering this question, for enabling ANOVA to be applicable, the same question is rewritten in equivalent modified form as follows:

The research question is:

Is there a significant difference among the average amount of money spent (numeric) of the 11 types of distribution channels (non-numeric), ANOVA is the appropriate choice as follows:

H0: Null Hypothesis: ( There is no significant difference among the average amount of money spent (numeric) of the 11 types of distribution channels (non-numeric)

HA: Alternative Hypothesis: ( There is no significant difference among the average amount of money spent (numeric) of the 11 types of distribution channels (non-numeric)

In ANOVA, the independent variable is of nominal scale.The dependent variable is continuous.

orchestra answered 2 years ago

I do not understand how you post it. When I put some of the answers in,...

I do not understand how you post it. When I put some of the answers in, they are wrong. Comprehensive Problem 5 Part B: Note: This section is a continuation from Part A of the comprehensive problem. Be sure you have completed Part A before attempting Part B. You may have to refer back to data presented in Part A and use answers from Part A when completing this section. Genuine Spice Inc. began operations on January 1 of the...

Compare and contrast t-test and ANOVA: 1. what do they test for? 2. How do they...

Compare and contrast t-test and ANOVA: 1. what do they test for? 2. How do they do it? 3. When would you use them?

When do you use a one-tailed test? When do you use a two-tailed test? How is...

When do you use a one-tailed test? When do you use a two-tailed test? How is SPSS used to perform the calculations needed for each?

# Do not delete this cell. You have to run this cell to test your code...

# Do not delete this cell. You have to run this cell to test your code in the test cases. score = dict() # This function will search the given text in order to find a given word def is_word_there(text, word): """ What it takes? a text to be searched a word to be searched within a text what it does? searches if a word occurs in a text What...

While conducting an ANOVA test, how do you identify a list of possible contrasts and comparisons?

How can I do one-way ANOVA in RStudio?

1.a). When do researchers use ANOVA vs. Chi-square test? Indicate two main characteristics of ANOVA and...

1.a). When do researchers use ANOVA vs. Chi-square test? Indicate two main characteristics of ANOVA and Chi-square tests (two for each test). 1.b). What are some of the major limitations of both ANOVA and Chi-square tests? (at least two for each)

Suppose you run some tests to see how the share price behaves when you change some...

Suppose you run some tests to see how the share price behaves when you change some of the inputs and drivers utilized in arriving at that value. You keep all other variables the same and look at the isolated effect that each of the selected inputs has on share price. What are you doing? A.) Performing scenario analysis B.) Performing sensitivity analysis C.) Performing Monte Carlo simulation

I have the solution.. I just do not know how they came up with some of...

I have the solution.. I just do not know how they came up with some of the answers. e.g. sales return and allowande. Exercise 5-11 Calculating income statement components L01,5 Referring to Exhibit 5.15 calculate the missing amounts (round to two decimal places). Company A Company B 2020 2019 2020 2019 Sales $263,000.00 $187,000.00 ? 114200.00 $48,500.00 Sales Discount $2,630.00 ? 1350.00 $1,200.00 $570.00 Sales Return and Allowance ? 51570 $16,700.00 $6,200.00 ? 2430.00 Net Sales ? 208800.00 $168,950.00...

When already given tool values, how do I create cut-off values from scratch for a screening...

When already given tool values, how do I create cut-off values from scratch for a screening tool?

Question