Analyzing Data Using Pivot Tables – An Example Remember assignment 5 where you were asked to compare Invoice amounts to Sales Order amounts? You had to create a query to join together 2 tables from an Access database. If the results of that query had been downloaded into an Excel file (a simple thing to do)‚ you could have used the Excel file and a Pivot table to help in the analysis. Before you try to follow this example‚ you should learn as much as you can about Pivot Tables from Microsoft’s
Premium Spreadsheet Microsoft Excel Microsoft Office
Experiment 5: VARIATIONS IN PROPERTIES IN THE THIRD ROW OF THE PERIODIC TABLE INTRODUCTION The periodic table is a tabular display of the chemical elements‚ organized on the basis of their atomic numbers and chemical properties. Elements are presented in increasing atomic number. Elements with the same number of valence electrons are kept together in groups‚ such as the halogens and the noble gases. Due to this‚ there are gaps that form four distinct rectangular areas or blocks. The f-block
Premium Periodic table Chemistry Chemical element
that something was a chemical change? I viewed my other test tubes to see if it there was a chemical change in those. C. Give at least two examples of chemical changes you observed. Zn and MgO when I Diluted HCL D. Classify the following properties of sodium metal as physical or chemical: • Silver metallic color: Physical • Turns gray in air:chemical • Melts at 98ophysical • Reacts explosively with chlorine gas: chemical E. Classify the following changes as physical or chemical: •
Premium Sodium Color Green
gradually became closer to purple/blue (darker colour) - As NaF became less concentrated in the solution‚ it gradually became closer to peach/colourless (lighter colour) Key: Peach=1 Pink=2 Lilac=3 Mauve=4 Purple=5 Blue=6 Reasurize Processed Data Calculate the average= Average degree of colour change= Group 1 Group 2 trial1+trial2+trial3+trial4+trial5+trial1+trial2+trial3+trial4+trial5/numberof trials A=1+2+2+2+2+1+1+1+1+1/10=
Premium Concentration Change
PROPERTIES OF SOLUTIONS A solution is a mixture of materials‚ one of which is usually a fluid. A fluid is a material that flows‚ such as a liquid or a gas. The fluid of a solution is usually the solvent. The material other than the solvent is the solute. We say that we dissolve the solute into the solvent. Some solutions are so common to us that we give them a unique name. A solution of water and sugar is called syrup. A solution of sodium chloride (common table salt) in water is called brine
Premium Water Sodium chloride Carbon dioxide
to providing her customers with the best selection of fine foods and great wines. Evaluation of the design elements The Inventory Table contains the components that make up an Item. It is used for managing inventory and determining the availability of ingredients that go into prepared items‚ such as bakery products‚ etc. First‚ the table organizes the financial data into department‚ then financial account codes‚ item‚ and then sums the total amount of transactions for the code and then counts how
Premium Microsoft Office Microsoft Excel Spreadsheet
Data Table Analysis Introduction Kudler Fine Foods was founded by Kathy Kudler in the summer of 1998 in La Jolla‚ California. Two other stores were opened at Del Mar and Encinitas California‚ Kudler Fine Foods deals in specialty foods sells; fresh bakery/Pastries fresh produce fresh meat & seafood condiments and packaged foods cheese’s and specialty dairy products (Kudler Fine Foods‚ 2003). The Entity Relation diagram and pivot table would help Kudler Fine Foods improve the data tables and
Premium Marketing Customer service Food
Name: ____Justine Basilone___ Osmotic Regulation Virtual Laboratory Biology Go to the following virtual laboratory: http://www.glencoe.com/sites/common_assets/science/virtual_labs/LS03/LS03.html Answer your questions in this word document‚ save the file and submit through Edmodo. Your answers should be at least 2 complete sentences if not more! Part I: Observations & Data: Read the Introductory information and the Procedure located in the window to the left of the screen and
Free Cell membrane Cell wall Red blood cell
A detailed explanation‚ one paragraph or more in your own words‚ of the colligative property being discussed and why that property changes the way that it does when the amount of solute is increased. A detailed description‚ at least one paragraph‚ of a real-world application of the colligative property‚ including an explanation of how this application of the colligative property is important or useful to those affected. The real-world example must be one that was not mentioned in the lesson. An
Free Freezing-point depression Solutions Boiling point
The effect of environmental factors such as temperature‚ osmotic pressure‚ oxygen concentration and pH on microbial growth and survival Abstract: Microbial growth can be affected by different environmental factors such as temperature‚ osmotic pressure‚ oxygen concentration and pH. Six experiments were carried out in this report testing for microbial growth against different environmental factors. Good aseptic techniques were used to prevent contamination‚ resulting in a uniform set of results
Premium Bacteria Escherichia coli Microbiology