Excel Spreadsheet

Part I: Sorting and Graphing

1. Determinethe sorts for Sorts #1, #2, and #3. You will need to use the sort function in excel to explore how a data set based on paint names and property values produced three different sorts: Sort #1, Sort #2, and Sort #3. To do this, select the entire body of data from B7 to H23 then click on Sort and Filter up on the top Ribbon, then click on Custom Sort. Here, as long as the “My Data has Headers” box is checked, you’ll be able to select columns to sort and then a parameter to sort them by (alphabetically, numerically, largest to smallest, A to z, etc). By clicking “Add Level” you can introduce multiple sorts at once where it will do the first sort and then continue to sort the data according to the second sort. This function is a bit trickier so take your time to explore it and discover how it is changing your data. As you discover each sort, type it into a new cell off to the right, for example from the weekly video: “Sort #2 is sorted alphabetically from A to Z of the Paint Name.”

Don't use plagiarized sources. Get Your Custom Essay on
Excel Spreadsheet
Just from $13/Page
Order Essay

2. GraphColor ID vs. Sorts #1 – #3. Stateany correlations that you find. All graphs, unless specified otherwise, should be scatter plots without any connecting lines. Graphelements that must be included are axis titles (including units if applicable), graph title, adjusted axis values (the data should take up the majority of the graph space), a legend, and clearly distinct marker colors. Make sure to watch the video for examples. If any correlation is seen between Color ID and any of the sorts, state that correlation in a cell near the graph. You have freedom to organize your excel as you see fit as long as it is easy to read!

3. GraphBrightness vs. Sorts #1 – #3. Stateany correlations that you find.

4.  GraphSheen vs. Sorts #1 – #3. State any correlations that you find.

Part II: Graphing and Formatting Equations and Trendlines

1. Graph the activation energy vs temperature data. Again, for credit, make sure that the graph is made properly and all graph elements are present and organized well.

2. Determinethe best trendline for the data (equation and R2 value shown on graph). Right click on your graph data and then click on “Add Trendline.” Check the boxes on Display Equation on chart” and “Display R-squared Value on chart.” Experiment with the different types of trendlines available and different orders of polynomial to determine the best fit trendline. Again, the video walks through this process one step at a time with hints.

3. Createa calculated activation energy column. Once you’ve determined the best fit for the data, you’re going to recalculate the data in a new column using the equation from your trendline. Remember that in the equation “y” is your activation energy and “x” is your temperature in Kelvin (which is a cell you’ll reference). You’ll want to be thinking about graphs in this sense throughout this semester since it will help bridge the gap between a math equation and a real life application. For example, the trendline that I got in the video is more accurately thought of as: EA (mJ) = -3.0000×10-3T4 + 1.1000×10-1T3 + 5.0000×10-1T2 + 1.0004T – 5.2828. Make sure that you label your calculated column correctly and always include units.

4.  Createa difference column between actual activation energy and calculated. Create a new column and set it to equal the actual activation energy data minus the calculated data for each temperature. It’s ok if this value is zero!

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Writall
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Business Studies
Hello Can I please get a copy of a plagiarism report? Thanks, Dan
Customer 454899, September 30th, 2021
Greater than anticipated. Thanks for the start.
Customer 454569, November 8th, 2020
Social Work and Human Services
Thanks a million!!
Customer 453933, October 7th, 2020
I've used this service 3 times and this was by far the best paper I've received. Awesome job by the writer. Thank you for the assistance!
Customer 455113, November 22nd, 2021
Great writer
Customer 454983, February 14th, 2022
Excellent!! Great Work Exactly what I needed!!!!
Customer 455199, December 15th, 2021
Great Work as Usual. Thank you . I received an A on the paper!
Customer 454497, March 29th, 2021
I am so thankful!
Customer 454593, November 24th, 2020
Health Care
Excellent job
Customer 454677, March 9th, 2021
Thank you
Customer 454677, March 18th, 2021
Social Work and Human Services
I love how the writer pays attention to detail, this is allowing me great opportunity to learn even more from his writing styles!!
Customer 453933, October 1st, 2020
very satisfied
Customer 454099, May 22nd, 2020
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
Live Chat+1(978) 822-0999EmailWhatsApp

Order your essay today and save 20% with the discount code GOLDEN