Sending you the worksheet with GINA Analysis
It is one DV Sales and four IVs Ad Spend, Price, Staff and Competitor Price
Column B to F : Original Data
Column H to L : Calculation of Min-Max normalization used to make all values 0-1.
Column M to Q : Absolute difference between DV and each IV at each point.
Column R to U : Grey Relational Coefficients
For DV and all the IV it is assumed that bigger value is better
Results are as under
|
|
Grey Relational Grades |
Rank |
|
|
Influence of AdSpend |
0.807504162 |
1 |
|
|
Influence of Price |
0.750898871 |
2 |
|
|
Influence of Staff |
0.712677939 |
3 |
|
|
Influence of Competitor Price |
0.650821617 |
4 |
|
|
Interpretation |
AdSpend has the highest grey influence on Sales |
||
|
I have taken the help of AI for calculations and Data used is generated thru AI |
|||
Regards
Sunil
--
The members of this group are expected to follow the following Protocols:
1. Please search previous posts in the group before posting the question.
2. Don't write the query in someone's post. Always use the option of New topic for the new question. You can do this by writing to dataanaly...@googlegroups.com
3. It’s better to give a proper subject to your post/query. It'll help others while searching.
4. Never write Open-ended queries. This group intends to help research scholars, NOT TO WORK FOR THEM.
5. Never write words like URGENT in your posts. People will help when they are free.
6. Never upload any information about National Seminars/Conferences. Send such information
in personal emails and feel free to share any RESEARCH-related information.
7. No Happy New Year, Happy Diwali, Happy Holi, Happy Birthday, Happy Anniversary, etc. allowed in this group.
8. Asking or sharing Research Papers is NOT ALLOWED.
9. You can share your questionnaire only once.
---
You received this message because you are subscribed to the Google Groups "DataAnalysis" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dataanalysistrai...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/dataanalysistraining/CAJoqpsMU1Aa1A2ArOd%3DbUw6FCK%2Br%2BSy5-ToTu5qUfCKEp_d2LQ%40mail.gmail.com.