Solved You are a Consultant who Works for The Diligent

Running head: MODULE 3 - CASE
MODULE 3 - CASE
Name of the Student
Name of the University
Author Note

MODULE 3 - CASE1
Introduction:
In this particular report consulting advices are provided as a consultant of Diligent
Consulting Group to the get an idea of motivation of the customers’ for buying the organic
foods. Now, the customers’ motivation of buying organic foods is assumed to be affected by
the age of the customers. Hence, a linear regression analysis is performed to express the
annual amount spent in Organic foods in terms of ages of customer. Now, the dataset which
is used for performing linear regression is provided with the case study in excel file and have
two variables namely Annual amount spent by the customers on organic food and age of the
customers (Cohen & Migliorati, 2016). The dataset has 124 instances with no missing values
or the effective sample size for linear regression is 124. Now, measures of central tendency
and dispersion of the variables can provide an overview of the entire data. Thus these are
calculated under the descriptive statistics using excel as given below.

MODULE 3 - CASE2
Descriptive statistics:
Annual Amount Spent on Organic
Food
Age
Mean 11046.48 Mean 48.23387
Standard Error 334.8137 Standard Error 1.463298
Median 11198 Median 46.5
Mode 10800 Mode 38
Standard Deviation 3728.327 Standard
Deviation
16.2946
Sample Variance 1390042
6
Sample Variance 265.514
Kurtosis -0.81194 Kurtosis -1.11557
Skewness 0.152019 Skewness 0.12932
Range 15373 Range 57
Minimum 2800 Minimum 21
Maximum 18173 Maximum 78
Sum 1369764 Sum 5981
Count 124 Count 124