+1 8108305898 essaysprings@gmail.com

Descriptive Statistics: Monthly Product SalesYour organization has collected monthly sales data on one product along with the promotional expense dollars for radio, newspaper, TV, and Point of Sale ads spent in advertising the company’s product. Your task is to conduct descriptive analytics on a sample data set named prod_sales.xlsx (accessed by clicking “next” at the bottom of this page). The variable names can be found in the first row of the file.

You are expected to perform the appropriate descriptive statistics tests and prepare the appropriate tables, charts, and graphs needed to describe data. After conducting the descriptive statistics tests, you must provide two business questions that this data is capable of answering and alternate and null hypotheses for each business question.

Submit the following items for this assignment:

  • Screenshots of the results for each statistical test including any charts, graphs, and tables.
  • Two business questions including how this data can answer the questions
  • Alternate and null hypotheses for each business question
  • What story is the data telling us?
  • What business insights can the organization gain from the visualizations?
  • Analysis of potential relationships in the data that should be investigated further.

Your paper must be three to five pages in length (not including the title page and reference page), organized, and well-written.

In support of your response, cite and integrate at least two scholarly sources. Place these in a reference page formatted in accordance with APA style.

Figure notation for screenshots should comply with APA guidelines.

Descriptive Statistics: Monthly Product Sales Your organization has collected monthly sales data on one product along with the promotional expense dollars for radio, newspaper, TV, and Point of Sale
MIS 5 40 M od 3 C T O ptio n 2 .d ocx by G ild a P au ra Su bm is sio n d ate : 0 6-F e b -2 022 0 7:1 4PM (U TC -0 700) Su bm is sio n I D : 1 756339919 File n am e: M IS 540_M od _3 _C T_O ptio n _2 .d ocx (9 72.3 9K ) W ord c o unt: 9 36 C hara cte r c o unt: 5 258 5 2 2 2 1 1 1 1 1 1 1 1 1 3 4 40 % SIM IL A RIT Y IN DEX 3 8 % IN TER N ET S O URCES 0 % P U BLIC A TIO NS 1 1 % STU DEN T P A PER S 1 2 9 % 2 4 % 3 3 % 4 2 % 5 1 % Exclu de q uote s O ff Exclu de b ib lio gra p hy O ff Exclu de m atc h es O ff M IS 5 40 M od 3 C T O ptio n 2 .d ocx ORIG IN ALIT Y R EPO RT PRIM ARY S O URC ES r s tu dio -p ubs-s ta tic .s 3 .a m azo naw s.c o m In te rn et S o urc e h br.o rg In te rn et S o urc e S u bm it te d t o U niv e rs it y o f A riz o na Stu den t P ap er w ww.t a n dfo nlin e.c o m In te rn et S o urc e S u bm it te d t o C olo ra d o S ta te U niv e rs it y , G lo bal C am pus Stu den t P ap er