代写Data analysis代做Python编程

Case:

VerdeVista Market (VVM) is a premium food retailer, featuring up-market, organic, and locally sourced products. One of their recently acquired suppliers, Mama Jen’s, is a local strawberry and blueberry farm, supplying VVM with a premium branded 150ml jars of hand-made organic strawberry jams.

One of the selection criteria that Mama Jen’s had to meet was the consistency of the fill volume of each jar of jam. VVM will not tolerate inaccurate or highly variable fill rates in their product. As part of the entry requirements, Mama Jen’s had to submit three descriptive measurements from a random sample of 200 random jars of their 150ml strawberry jams.

a.  which three descriptive measurements would VVM have asked for from Mama Jen’s for such evaluation? Justify your suggestions by explaining why VVM would choose each measurement.

b.  The sample fill volume data from the 200 random jars of 150ml strawberry

jams are stored in another file. Use Excel to generate the three descriptive measurements nominated in part a. Verify your calculations using R Studio. State the values of the three measurements and upload files containing your workings and outputs on Excel and R Studio as part of your submission.

c.  In VVM’s perspective, evaluate all three descriptive measurements for the

purpose of supplier selection (based on information in the case). For each of the three measurements, suggest and briefly explain one limitation in its use for VVM’s purpose.

Fill in your answers to this question into the spaces in the following answer template. Adhere to the word count guidelines where applicable.

a.

Descriptive Measurement #1:

Justification (limit your answer to 30 words):

Descriptive Measurement #2:

Justification (limit your answer to 30 words):

Descriptive Measurement #3:

Justification (limit your answer to 30 words):

b.

Value of Descriptive Measurement #1:

Value of Descriptive Measurement #2:

Value of Descriptive Measurement #3:

Have you submitted the evidence of Excel Working? (Yes/No):

Have you submitted the evidence of R Studio Working? (Yes/No):

c.

VVM’s evaluation based on Descriptive Measurement #1 (limit your answer to 50 words):

One Limitation:

VVM’s evaluation based on Descriptive Measurement #2 (limit your answer to 50 words):

One Limitation:

VVM’s evaluation based on Descriptive Measurement #3 (limit your answer to 50 words):

One Limitation:

VVM wants to finalise the agreement to partner with Mama Jen’s. Before doing so, it wants to more rigourously review Mama Jen’s fill accuracy performance by using hypothesis testing, hoping to get results with an indication of the associated significance and confidence level. Help VVM by carrying out the following steps and answering the questions.

a.  Define the null and alternative hypotheses for a suitable hypothesis test.

b.  list all relevant “ingredients” required for this hypothesis test. Use the data in the .csv file to generate their values if necessary. You may use Excel or R to do this. No submission of evidence of workings required for this part.

c.  Calculate and report the values of the upper and lower non-rejection limits. Clearly lay out all steps involved in the workings to get full marks.

d.  Carry out the hypothesis test by using the outputs from part c. State the  resulting conclusion (reject or not reject) with justification in your answer.

e.  In natural language, describe what the conclusion from part d means for

VVM’s decision. Using the information available, describe the likelihood that the conclusion from the hypothesis test being erroneous (presuming that all your calculations are correct).

Fill in your answers to this question into the spaces in the following answer template. Adhere to the word count guidelines where applicable.

a.

The Hypotheses:

b.

The “Ingredients”:

c.

Calculations:

Upper Rejection Limit:

Lower Rejection Limit:

d.

Conclusion (limit your answer to one sentence):

Justification (limit your answer to 30 words):

e.

The meaning of the conclusion from part d in natural language (limit your answer to one sentence):

Likelihood of the conclusion being erroneous (limit your answer to one sentence):

Sum up the case situation in this Assignment and the investigations performed in questions 1 and 2 by describing each step of the P.A.I.D. decision support process undergone by VVM. Include in your description an appropriate decision for VVM, embedded in the description of the appropriate step.

Fill in your answers to this question into the spaces in the following answer template. Adhere to the word count guidelines where applicable.

Step 1 – Define the Problem (limit your answer to 30 words):

Step 2 – Analyse the Data (limit your answer to 30 words):

Step 3 – Generate Insight (limit your answer to 30 words):

Step 4 – Support Decision (limit your answer to 30 words):