Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone help me do regression or give me instructions on how to do it? I have to perform inferential statistics to interpret the P-value

Can someone help me do regression or give me instructions on how to do it? I have to perform inferential statistics to interpret the P-value or F-value to decide the significance of the results.

Attached is what I have so far. I am not sure on how to proceed.

image text in transcribedimage text in transcribedimage text in transcribed
Consumer behavior tends to vary depending on factors like age, gender, salary, occupation, etc. Hence generic information about consumers (age, gender, salary, and occupation) has been included. In an effort to increase sales, I'm trying to develop a new product. I want to be more aware of who MSIL should be targeting to sell to. Using this data will make developing an optimal target consumer profile easier. EXHIBIT 6: PROFILE OF EXISTING A-SEGMENT CONSUMERS IN INDIA Monthly average household income Occupation in percentage Avg. age Less $50,000 Avg. First- in than family time Self- Middle Govt. Segment years $50,000 *75,000 size buyer employed Management Professional employee Entry- hatch 37 21% 63.40% 4.68 61% 51 14 Mid- hatch 36 17% 71.60% 5 59% 45 12 15 Premium- hatch 34 11% 77.80% 4.57 50% 55 12 14 Source: Company materials. According to the data, 54% of consumers in the A-segment were first-time buyers, with an average age of 35. Avg.35.66 37 36 34 40 30 20 Avg.ag 10 Avg.age Anova: Single Factor SUMMARY Groups Count Sum Average Variance First vehicle 217.9 54.475 40.70916667 addiitonal vehicle 93.7 23.425 17.87583333 replacement 88.2 22.05 24.63 ANOVA Source of Variation SS if VS P-value F crit Between Groups 2689.831667 2 1344.915833 48.48581986 1.51613E-05 4.256494729 Within Groups 249.645 27.73833333 Total 2939.476667 11]2 The average consumer is self-employed, according to consumer occupation statistics. However, "Premium-hatch" has the highest value for "Self-employed" and the lowest value for "First time buyers," which is inconsistent given that the majority of our customers are first-time buyers. Anova: Single Factor SUMMARY Groups Count Sum Average Variance Self-employed 151 50.3333333 25.3333333 Middle Management 35 11.6666667 0.3333333 w w w w Professional 43 14.3333333 0.33333333 Govt. employee 9 6.33333333 5.33333333 ANOVA Source of Variation S MS P-value F crit Between Groups 3620 3 1206.66667 154.042553 2.0494E-07 4.06618055 Within Groups 52.6666667 8 7.83333333 Total 3682.66667 11 Self-employed Entry-hatch Premium-hatch 33.8% 36.4% Mid-hatch 29.8%w According to consumer average income data, most customers have monthly incomes between $50,000 and $75,000 and a preference for premium-hatch. Anova: Single Factor SUMMARY Groups Count Sum Average Variance less than *50,000 0.49 0.16333333 0.00253333 $50,000 -

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

Trigonometry (Subscription)

Authors: Mark Dugopolski

5th Edition

0135207487, 9780135207482

More Books

Students also viewed these Mathematics questions

Question

3. An initial value (anchoring).

Answered: 1 week ago

Question

4. Similarity (representativeness).

Answered: 1 week ago