i need excel expert
Budget: ₹600 – ₹1,500 INR
. A music company is in the process of developing marketing plan for the next year to maximise their product sales. They have hired your company for doing marketing research and to understand what they should do to increase their sales. In support of your they have also provided data of previous year sales. This data set includes following variables. (Use Data: Music) 15 Marks
ID = Artist ID
Sales = Sales of music albums (thousands of units),
Ad = Dollars spend on advertisement,
Air_time = the number of times music played on TV per week,
Rating = Rating of artist (1-10 scale),
Origin = Artist origin country (0 = local, 1 = international),
Genre = (1 = pop, 2 = electronic, 3 = rock).
Success = (0 = hit, 1 = flop)
(i) Examine the normality of all metric variables. 2 Marks
(ii) Before analysing the above data, you have to examine whether there is any outlier or not. In case of any outlier present in dataset you have to replace it with mean value in case of metric variable and with mode in case of non-metric variables. 2 Marks
(iii) What is the average sale of music albums, advertisement spending, Airtime. 1 Marks.
(iv) Use appropriate tool to examine the impact of various metric and non metric variables on sales of music album. Determine the fitness of your model and the effect above mentioned variables on sales. 5 Marks
(v) Also, you have to find out is there any relationship:
a) between Genre and Success of music album 2.5 Marks
b) between Origin of artist and Success of music album 2.5 Marks
All the above answers must be submitted in the form of a report and hypothesis development, analysis and interpretation of results, wherever applicable should also be included.
Q2. Using the Music dataset answer the following questions. In each case formulate the null and alternate hypotheses and conduct the appropriate statistical test(s). 5 Marks
I. Company wants to know does higher ad spending leads to:
a) improvement in rating or
b) improvement in sales. 2 Marks
II. Is there any relationship between genre with sales? Also find out average sale of each genre category. 2 Marks
III. Does the rating differ by origin of artist? 1 Mark
ID = Artist ID
Sales = Sales of music albums (thousands of units),
Ad = Dollars spend on advertisement,
Air_time = the number of times music played on TV per week,
Rating = Rating of artist (1-10 scale),
Origin = Artist origin country (0 = local, 1 = international),
Genre = (1 = pop, 2 = electronic, 3 = rock).
Success = (0 = hit, 1 = flop)
(i) Examine the normality of all metric variables. 2 Marks
(ii) Before analysing the above data, you have to examine whether there is any outlier or not. In case of any outlier present in dataset you have to replace it with mean value in case of metric variable and with mode in case of non-metric variables. 2 Marks
(iii) What is the average sale of music albums, advertisement spending, Airtime. 1 Marks.
(iv) Use appropriate tool to examine the impact of various metric and non metric variables on sales of music album. Determine the fitness of your model and the effect above mentioned variables on sales. 5 Marks
(v) Also, you have to find out is there any relationship:
a) between Genre and Success of music album 2.5 Marks
b) between Origin of artist and Success of music album 2.5 Marks
All the above answers must be submitted in the form of a report and hypothesis development, analysis and interpretation of results, wherever applicable should also be included.
Q2. Using the Music dataset answer the following questions. In each case formulate the null and alternate hypotheses and conduct the appropriate statistical test(s). 5 Marks
I. Company wants to know does higher ad spending leads to:
a) improvement in rating or
b) improvement in sales. 2 Marks
II. Is there any relationship between genre with sales? Also find out average sale of each genre category. 2 Marks
III. Does the rating differ by origin of artist? 1 Mark