Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

aa

aa

DEPARTMENT OF CHEMICAL ENGINEERING

CHEG 3101-P02: CHEMICAL ENGINEERING LABORATORY I

COURSE ASSIGNMENT GRADING AND OUTCOME

Produce diagrams and tables such as PIVOT Tables of experimental results or raw data.

45 Points

Correctly analyze or interpret the date 45 Points.

Class Participation 10 Points

Creating a Pivot Table Assignment

A pivot table is a great way to summarize data in Excel. This tool can automatically sort, count,

and sum data into summarized data tables. Pivot tables use a feature called crosstabs which

summarizes data into a concise format for easier analysis or reporting. A pivot table usually

consists of row, column, and data fields.

For this assignment, you will analyze the nutrition information for select food data.

Step #1: Obtain Pivot Table.

1. Rename the worksheet Raw Data.

2. On the Ribbon, click the Insert tab.

3. Select the Table icon. Your data is placed into categories and should having alternating color

rows.

4. Click on the Table Tools Design tab. Select a new Table Style for your data.

5. Next, Click the Summarize with PivotTable icon. A new window will appear. Make sure that

New Worksheet is select and click OK.

6. In the new Worksheet window, change the PivotTable Name to CA1PIVOT.

7. On the right-hand side, you will see options for PivotTable Fields. Check all boxes in the

search field.

8. A PivotTable will appear in a new sheet. Name your new sheet Original.

Step #2: Obtain Summary PivotTable 1.

1. Create a copy of your Original worksheet (ask for assistance). Rename the copy Summary 1.

2. For Summary 1, select Category, Food Item, and Fat (g). You will have a PIVOT Table for

with only this information present.

3. In the bottom right hand corner of the PivotTable Fields, you will find sections for Filters,

Columns, Rows, and Values.

4. Under Values, click on Sum of Fat (g) and select Change Value Field settings.

5. Change Sum to Average.

6. Click the Number Format button. A new window will open. Select number and change the

number of decimal places to 1. You will now have a table of categories and average fat(g).

Step #3: Adding Standard Deviation and Graphing Summary PivotTable

1. Each category has a + sign next to its name. Clicking on it will expand the information.

2. You will use this information to determine the standard deviation of each category.

3. Under the Analyze Tab, select PivotChart. Determine the best graphing method for this data.

Step #4: Creating Summary PivotTables

1. For the remaining Summary PivotTables, you will create graphs based on

a. Average calories and standard deviation of Fast Foods only

b. Average carbs and standard deviation of mixed dishes only

c. Average protein and standard deviation of soups only

2. Choose the best graphing method for each

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Computer Science 2 Assignments

Operational Excellence Week 2 Assignment Information Systems for Business and Beyond Questions: · Chapter 3 – study questions 1-8, Exercise 2, 4 & 5 Information Technology and Organizational Learning Assignment: Chapter 3 – Complete the two essay assignments noted below:  · Review the strategic integration section.  Note what strategic integration is and how

Discussion 3: generative adversarial nets

  Generative adversarial nets are mentioned in 2014 by Ian Goodfellow et al.  Why is generative adversarial network a key turning point in the history of generative modeling? Why is the field of image generation important? 

Week 3 – Linear Regression & Business Decision Making

attached file.  An asset management company must replace the manager of its two signature mutual funds, who is about to retire. Two candidates have been short-listed. The management team is divided and cannot decide which of the two candidates would make the better mutual fund manager. The retiring manager presents

data science

Final Exam Due Saturday 11:59 pm (Week 15) You cannot use any of the datasets in our assignments, class notes, and your own midterm project. If you are using the same one, you will receive 0 for your final project. 1. Question Formulation (5 points): You need to devise a

Letter of Recommendations

Hi  Attached is the sample of Letter of recommendation  Please write about it accordingly  1. Write about author :AUTHOR WILL BE professor David Kimble I will give links about his Biography write accordingly or you can use your own search engines about him to write it. 2 . How the

Letter of Recommendations

Hi  Attached is the sample of Letter of recommendation  Please write about it accordingly  1. Write about author :AUTHOR WILL BE professor David Kimble I will give links about his Biography write accordingly or you can use your own search engines about him to write it. 2 . How the

data science

Final Exam Due Saturday 11:59 pm (Week 15) You cannot use any of the datasets in our assignments, class notes, and your own midterm project. If you are using the same one, you will receive 0 for your final project. 1. Question Formulation (5 points): You need to devise a

IT 202

5/15/24, 10:59 AM Assignment Information 1/3 IT 202 Project One Milestone Guidelines and Rubric Overview For the purposes of this assignment, imagine that you are a systems architect at a medium-sized publishing company with 130 employees. The company primarily publishes books, both in print and online. It also produces other

Assessments

Perimeter defense techniques Evaluate the types of assessments, select one that you might use, and explain why it is important. Of the top eight areas to research when conducting an assessment, select no less than three and explain how one should approach the research and why it should be approached

project ppt presentation

Project 3 – Ensemble Methods and Unsupervised Learning In this project you will explore some techniques in unsupervised learning as well as ensemble methods. It is important to realize that understanding an algorithm or technique requires understanding how it behaves under a variety of circumstances. You will go through the

Week 2 understanding on Python.

PDF for reference purpose other file is requirement Python Installation & Examples Atif Farid Mohammad PhD 1. Open any Browser 2. Go to 3. Click at Download button 4. Go to your Download Folder (In both Windows and Mac) a. In Windows you will have the file: Anaconda3-2022.05-Windows-x86_64.exe b. Double

Computer Science Assignments

Operational Excellence Week 2 Assignment information Systems for Business and Beyond Questions · Chapter 2 – study questions 1-10, Exercise 2      Information Technology and Organizational Learning Questions · Chapter 2 – Note why the IT organizational structure is an important concept to understand.  Also, note the role of

Computer Science IT project assignment

Pg. 01 Project I Project Deadline: Sunday 12/5/2024 @ 23:59 [Total Mark is 14] Introduction to Database IT244 College of Computing and Informatics Project Instructions · You can work on this project as a group (minimum 2 and maximum 3 students). Each group member must submit the project individually with

project ppt presentation

Project 3 – Ensemble Methods and Unsupervised Learning In this project you will explore some techniques in unsupervised learning as well as ensemble methods. It is important to realize that understanding an algorithm or technique requires understanding how it behaves under a variety of circumstances. You will go through the

coding

Assignment 6 Due Saturday 11:59 pm (Week 14) Part 1 (50 points) We will explore the Marvel Network Universe. The dataset which you will find in Blackboard consists of the hero’s networks. For this dataset, you will need to ask yourself 3 questions (i.e which superhero knows more superheroes?) ,

project ppt presentation

Project 3 – Ensemble Methods and Unsupervised Learning In this project you will explore some techniques in unsupervised learning as well as ensemble methods. It is important to realize that understanding an algorithm or technique requires understanding how it behaves under a variety of circumstances. You will go through the

How hackers get info

Identify at least two ways in which hackers gather information about companies. What can companies do to limit this access, specifically to the ways you have identified? Which type of information can be gathered with enumeration? How and why should companies protect themselves against enumeration attempts?