Description
I need help with a Excel Spreadsheet about the above: Here are the instructions. Please follow the instructions..I have attached the assignment (information) and the grading guide to ensure all information is included. This seems to be a very simple assignment.
PS - I HAVE TWO WEEKS OF ASSIGNMENTS. I WOULD LIKE TO USE THE SAME PERSON IF POSSIBLE
Signature Assignment: Creating Visuals from Data
+The purpose of this assignment is to have you practice creating visuals using the data from the topic you chose in Week 3. Creating charts and trendlines is an important skill used in many careers.
Watch How to Create Trendlines and Scatterplots in Excel®.
Watch Week 4 Lynda.com® Video: Adding Trendlines to Charts.
Create at least two visuals using your data.
- Create a scatter plot of the data, and apply a linear model (also known as a regression) in Excel®.
- Create a scatter plot of the data, and apply an exponential model in Excel®.
- Include the equation and R2 value on the visuals.
- Determine whether the linear or the exponential model is a better representation of your data to make your prediction. Explain why the model you chose is a better representation of your data.
Hints for Making an Effective Chart:
- Decide why you are making a chart from this data.
- Rename the chart title to something appropriate for the data.
- Put in a descriptive x-axis label.
- Put in a descriptive y-axis label.
- Resize the chart as needed so it is easily viewable.
Submit your visuals in either an Excel® file or a Word document. Your assignment will be graded using the Week 4 Grading Guide.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
The analysis is underneath the graphs. Please let me know if everything downloads properly. I have decided to put it in excel, since they give us the option.
Business Scenario
Scenario 5
Month
1
2
3
4
5
6
7
8
9
10
11
Predicting Fuji Apple Purchases
Review the monthly data involving Fuji apples purchased at a large grocery store. Predict how many Fuj
to have available for the customers in December (mont...