Premium Essay

Excel Project

In: Computers and Technology

Submitted By cjcjforever
Words 845
Pages 4
Research Proposal The Effects of Two Weight Management Treatments On Self-Perception Chellyn Jones English 1002 Columbia Southern University

Introduction
According to the American Obesity Association, over one-hundred million adults are overweight in the United States (2002). That is approximately one-third of the United States population (U.S. Census Bureau, 2006). Weight has a huge impact on the lives of many Americans with regards to health and social acceptance, which effect self-perception. The following article will outline the effects of two different weight management treatments, diet and diet with exercise, and which one improves self-perception most effectively. Many people struggle with being overweight and I believe that if more research is conducted and made available to the public, that information could reduce the sharp incline of obesity in the United States and save some lives from negative consequences of obesity such as diabetes, high blood pressure, heart disease, cancer, deep vein thrombosis, hypertension, pain, sleep apnea, stroke, and many other negative effects. (American Obesity Association, 2002).

Strength of Dieting
A research survey conducted by Gail Huon, et al. aimed to present a new way to measure dieting competitiveness and self-perception with regards to appearance of teenage girls by creating the Dieting Peer Competitiveness Scale (2001). During a normal class session, three hundred randomly chosen girls from three different high schools which ranged from private, religious, and government-funded school, were given several surveys. These…...

Similar Documents

Premium Essay

Excel Project

...where we have the highest market share. We identified the sales rep and have commended her for the job well done, promoting her to Regional Sales Manager. Graphic Recommendation The Regional Sales Manager will work closely with our Global HR Director, leveraging her extensive years of experience to identify training needs across our organization. The scope is to improve our sales tactics by implementing initiatives to increase customer satisfaction, for both existing customers and for new ones. One immediate decision is to incorporate account managers to assist in our customer support centers, due to both constant complaints from our customer and also feedback obtained by our top sales rep. SELF ASSESSMENT From completing the Excel project, I learned … * How to manipulate Pivot Tables to obtain a specific data set. * Incorporate a Chart, choosing the type of values to show (percentages, numbers) * Apply formatting to a table...

Words: 489 - Pages: 2

Premium Essay

Bis155 - Excel Project Memo

...Northwind Traders to focus and ramp up their sales efforts in other countries. Graphic Recommendation It is recommended that a greater effort be made to increase sales in other markets if the company wishes to see a substantial increase in total revenue. Much like increasing quarterly sales, more marketing and advertising dollars need to be focused towards the European markets where the company is experiencing the slowest growth. Also, the best way to increase sales in those markets is by increasing the productivity of the sales representatives in those areas. SELF ASSESSMENT From completing the Excel project, I learned that there are multitudes of ways to interrupt data to see similar yet slightly different results. I now have a firm grasp on how pivot tables, charts, and subtotaling data and how complex they can be as these were the methods I chose to use in my project. I also learned how to use the Top/Bottom 5 on products within my pivot table. That was a new skill I learned by exploring the functions during my analysis....

Words: 904 - Pages: 4

Premium Essay

Excel

...ADVANCED EXCEL TRAINING Quality Management Objective  To provide the participants with an understanding of the advanced features of MS Excel Today is 7/22/2011 2 Advanced  ® EXCEL Topics Working with Data Lists Naming Cells and Ranges   Conditional Functions Lookup Functions   Pivot Tables Data Validation  Today is 7/22/2011 3 Naming Cells and Ranges Today is 7/22/2011 4 Name cells by using labels Name cells by using existing row and column labels Select the range you want to name, including the row or column labels. On In the Insert menu, point to Name, and then click Create. the Create names in box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box. Note A name created by using this procedure refers only to the cells that contain values and does not include the existing row and column labels. Today is 7/22/2011 5 Name a Cell or Range Using Names Box  1. Select the cell or range you want to name.  2. Click the Name box on the formula bar.  3. Type a name for the range. A range name can include uppercase or lowercase letters, numbers, and punctuation, but no spaces. Try to use a simple name that reflects the type of information in the range, such as BookTitle.  4. Press Enter. The range name will appear in the Name box whenever you select the range. Today is 7/22/2011 6 Conditional......

Words: 1579 - Pages: 7

Free Essay

Excel

...11:14 PM 12/15/16 Project 4 Larry's Landscaping Open Invoices As of December 21, 2016 Type Date 11/18/2016 Num 141 P. O. # Terms Due Date 12/15/2016 Class Aging 6 Adam's Candy Shop Invoice Total Adam's Candy Shop Blackwell, Edward Invoice Total Blackwell, Edward Crenshaw, Bob Invoice Invoice Total Crenshaw, Bob Ecker Design Invoice Invoice Total Ecker Design 11/15/2016 134 Due on r... 11/15/2017 12/10/2016 11/25/2016 FC 8 135 Net 15 Net 30 12/25/2017 12/25/2017 Landsca... 11/30/2016 12/15/2016 111 131 Net 15 Net 15 12/15/2017 12/30/2017 Landsca... Maintena... Golliday Sporting Goods 155 Wilks Blvd. Invoice 11/30/2016 Total 155 Wilks Blvd. 75 Sunset Rd. Invoice Total 75 Sunset Rd. Total Golliday Sporting Goods Gregory, Dru Invoice Total Gregory, Dru Heldt, Bob Invoice Total Heldt, Bob Hermann, Jennifer Residential Maintenance Invoice 12/12/2016 Total Residential Maintenance Total Hermann, Jennifer Hughes, David Invoice Invoice Total Hughes, David Jim's Family Store Invoice Total Jim's Family Store Julie's Doll House Invoice Total Julie's Doll House Lee, Laurel Lee Residence Invoice Total Lee Residence Total Lee, Laurel Leon, Richard Invoice Total Leon, Richard 11/30/2016 11/18/2016 12/14/2016 11/24/2016 12/10/2016 8/23/2016 11/12/2016 12/2/2016 108 1% 10 N... 12/30/2017 Landsca... 120 Net 15 12/17/2017 Landsca... 97 2% 10 N... 12/12/2017 Landsca... 137 Net......

Words: 870 - Pages: 4

Premium Essay

Excel

...Hand Written Copy for Project One Paper support Assumption list Sales Budget | Unit Price | Input | Prior Month (March) Sales | Input | Unit Sales Increase | Input | | | | | Production Budget | Inventory On Hand | Input | Max Inventory (Greater Than) | Input | March 31, Total Inventory | Input | | | | | Materials Purchases Budget | Materials Needed Per Unit | Input | Sales Cut off | Input | High Sales | Input | Low Sales | Input | Price Per Pound | Input | Inventory On Hand | Input | Direct Labor Per Unit | Input | Min Hours Each Month | Input | Max Hours Each Month | Input | Hourly Wage | Input | Hours Greater Than 8,300 | Input | Over Time Wage | output | | | Other Manufacturing Cost Budget | Variable Cost Per Unit Produced | input | Monthly Equipment Rental Cost | input | Production Max | Input | Extra Rental Cost | input | | | Selling And Administrative Budget | Variable Cost Per Unit Sold | input | Managers Fixed Salary | input | Bonus | input | Max Sales | Input | Cash Collections | A/R Balance | Input | % Collected This Month | Input | % Collected Next Month | Input | | | Materials Accounts Payable Balance On | 3/31/2013 | input | | | Cash Budget | Pruchases Paid For In The Month Of Purchase | Input | Purchases Paid In Following Month Of Purchase | Input | April Purchases | input | May Purchases | input | June Purchases | input | ......

Words: 668 - Pages: 3

Free Essay

Excel

...Project Description: You are an analyst for an art gallery that is an authorized Greenwich Workshop® fine art dealer. You prepared a list of artwork by James Christensen and need to organize the data using an outline, subtotals, PivotTables, and PivotCharts to aid you in analyzing the data, which you will do in this project. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Download, save, and open the file named Exploring_e05_Grader_EOC.xlsx. 0 2 Sort the data on the Subtotals worksheet first by the Type column, then by the Art column, both in alphabetical order. 4 3 Subtotal the data at each change in Type. Identify the highest issue price, estimated value, and percent increase. 10 4 Add an automatic outline to the Subtotals worksheet. Group the first and last name columns. Collapse the names columns, and then collapse columns created by the outline (G, H, and I). 7 5 Create a PivotTable on a new worksheet using the data on the Christensen worksheet in the range A1:J19. Use the Type, Est. Value, and Issue Price fields and use the default locations in the PivotTable Layout. 8 6 Modify the Issue Price and Est. Value values to determine the average issue price and average estimated market value by type. 6 7 Insert a calculated field named % Change in Value to determine the percent change in values by type. Format the values in the new column as percentages......

Words: 312 - Pages: 2

Premium Essay

Excel

...Microsoft Excel 2010 Formulas & Functions  Table of Contents Excel 2010 Formulas & Functions ……………………………………………….….. o Formula Basics ……………………………………………….….. o Order of Operation ……………………………………………….….. Conditional Formatting ……………………………………………….….. Cell Styles ……………………………………………….….. Formulas & Functions ……………………………………………….….. Basic Formulas ……………………………………………….….. o Add the Values in Rows or Columns ……………………………………………….….. o Find the Average, Maximum, or Minimum ……………………………………………….….. Ranges & Individual Cells ……………………………………………….….. Copy a Formula ……………………………………………….….. o Using the Fill Handle ……………………………………………….….. o Using Traditional Copy & Paste ……………………………………………….….. Referencing Cells in Formulas ……………………………………………….….. o Relative References ……………………………………………….….. o Absolute References ……………………………………………….….. o Mixed References ……………………………………………….….. o References to Other Worksheets ……………………………………………….….. o Other Workbook References ……………………………………………….….. Quick Reference Guide ……………………………………………….….. o Add, Subtract, Multiple & Divide ……………………………………………….….. o Understanding Error Values ……………………………………………….….. Practical Purposes of Excel Formulas ……………………………………………….….. o Using Date & Time Formulas ……………………………………………….….. Commonly Used Functions & Formulas ……………………………………………….….. o Math & Trig Icon ……………………………………………….….. Logical Icon ……………………………………………….….. Lookup & Reference Icon ……………………………………………….….. Date & Time Icon ……………………………………………….….. AutoSum Icon ……………………………………………….…........

Words: 5629 - Pages: 23

Premium Essay

Excel

...New Perspectives Excel 2013 Tutorial 3: SAM Project 1a Spring Software ENHANCE A TIMESHEET Project Goal M Project Name Project Goal New Perspectives Excel 2013 Tutorial 3: SAM Project 1a Spring Software ENHANCE A TIMESHEET Project Goal M Project Name Project Goal PROJECT DESCRIPTION Devon Hastings is the human resources director for Spring Software, a software development company in Cambridge, Massachusetts. He has created a workbook for employees to use in recording the hours they work. He would like your help finishing the timesheet. GETTING STARTED * Download the following file from the SAM website: * NP_Excel2013_T3_P1a_FirstLastName_1.xlsx * Open the file you just downloaded and save it with the name: * NP_Excel2013_T3_P1a_FirstLastName_2.xlsx * Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically. * With the file NP_Excel2013_T3_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS 1. On the Employee List worksheet, select cells A1:B1 and then use the Format Painter copy the format only to the range A2:B9. 2. In cell B1 enter bs001, in cell B2 enter cg001, in cell B3 type dh001, and then use Flash......

Words: 790 - Pages: 4

Free Essay

Excel

...UVA-OB-0705 MAKING THE TOUGH TEAM CALL (A) Gudrun Dammermann-Priess was stunned after this latest round of project presentations. In the nine years since the international management program (IMP) began, she never had a project so bad that she considered not allowing it to go forward. With only six weeks until the final project deliverable in mid-May 2000—a 15-minute presentation in front of 100 top executives at Continental A.G., including the chief executive officer (CEO) and at least four other members of the Vorstand—the software team project was a potential embarrassment in a very high-stakes environment. The CEO’s concluding remarks from the previous year’s IMP–1999 echoed in her ears. “I would like all my top managers to take notice. If only your presentations were as good as those we have seen this afternoon.” The IMP program had risen substantially in stature and useful strategic output over the last several years, and the risks of presenting a poor project were, for Dammermann, acutely felt. Literally from the very first module of IMP–2000 in November 1999, when teams were put together and matched to mentors and projects, the three members of this project were in complete disagreement about almost every aspect of the project and its development. They disagreed on what the mentor wanted them to accomplish and how they might begin to approach answering the key questions. Furthermore, even though there were some personal interest overlaps, the styles of two team......

Words: 4631 - Pages: 19

Premium Essay

Excel

...P rate and y = T P rate. Possible values range from (0, 0) to (1, 1). The “classification” that assigns “Test Negative” to every score has FP rate of 0 and TP rate of 0, represented as point (0, 0). The “classification” that assigns “Test Positive” to every value has FP rate of 1 and TP rate of 1, represented as the point (1, 1). Joining all known (x, y) points by straight lines, the area under the resulting empirical ROC curve is known as the Area Under the Curve or AUC. The AUC ranges from 0.5, for a test no better than chance, to 1, for a perfect test. The Area Under the Curve is calculated by the summation of the average height multiplied by the width, as follows: ! ! T P (n) + T P (n + 1) 1 2 (F P (n + 1) F P (n)) See Excel Spreadsheets for examples of calculating each point on an empirical ROC Curve. 2 2.1 2.1.1 Information Measures Probability Review Basic Probability Definitions Joint probability: p(X, Y ) The probability that both X and Y are true. Joint probability is commutative: p(X, Y ) = p(Y, X). Conditional probability: p(X|Y ) The probability that X is true, given that Y is true. Note that “Rates,” PPV and NPV are Conditional Probabilities: True Positive Rate = p(T P T est|+), 3 False Negative Rate = p(F N T est|+), False Positive Rate = p(F P T est| ), True Negative Rate = p(T N T est| ), Positive Predictive Value = p(+|T est P ositive), Negative Predictive Value = p( |T est N egative). Marginal probability:......

Words: 4475 - Pages: 18

Premium Essay

Acct 370 Excel Project

...Acct 370 Excel Project Click Link Below To Buy: http://hwcampus.com/shop/acct-370-excel-project/ PART 1: Excel Project: Part V Instructions Common Sized Statements and Trend Analysis on WALMART Stores Inc. The tenth tab in your Financial Statement Analysis Template must be labeled Common Sized Balance SheetsThe eleventh tab in your Financial Statement Analysis Template must be labeled Common Sized Income StatementsThe twelfth tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Balance SheetsThe thirteenth tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Income StatementsInclude the latest three years for the common sized (vertical analysis) and horizontal analysis in Tabs 10–13. *PLEASE WORK OFF OF ATTACHED EXCEL SPREADSHEET. When you open the document, you will see that there are already 9 tabs. Follow the instructions above. You will need to add 4 more tabs labeled appropriately with the above titles (see instructions). Please save the work and send it back to me. PART 2: - Use WORD to complete this part COMPARITIVE ANALYSIS REPORT. - WALMART Examine common sized financial statements and ratios for the company you selected for the Excel project and two of its competitors. Write a 1000-word report in current APA format. Include the following in your report: Compare and contrast the selected company, its competitors, and industry averages Identify the selected company’s......

Words: 280 - Pages: 2

Premium Essay

Acct 370 Excel Project

...Acct 370 Excel Project Click Link Below To Buy: http://hwcampus.com/shop/acct-370-excel-project/ PART 1: Excel Project: Part V Instructions Common Sized Statements and Trend Analysis on WALMART Stores Inc. The tenth tab in your Financial Statement Analysis Template must be labeled Common Sized Balance SheetsThe eleventh tab in your Financial Statement Analysis Template must be labeled Common Sized Income StatementsThe twelfth tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Balance SheetsThe thirteenth tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Income StatementsInclude the latest three years for the common sized (vertical analysis) and horizontal analysis in Tabs 10–13. *PLEASE WORK OFF OF ATTACHED EXCEL SPREADSHEET. When you open the document, you will see that there are already 9 tabs. Follow the instructions above. You will need to add 4 more tabs labeled appropriately with the above titles (see instructions). Please save the work and send it back to me. PART 2: - Use WORD to complete this part COMPARITIVE ANALYSIS REPORT. - WALMART Examine common sized financial statements and ratios for the company you selected for the Excel project and two of its competitors. Write a 1000-word report in current APA format. Include the following in your report: Compare and contrast the selected company, its competitors, and industry averages Identify the selected company’s......

Words: 280 - Pages: 2

Premium Essay

Excel

...Applied Statistics Microsoft Excel Decomposition may reduce appeal emphasis on applications. Flow charts help make the analysis decision by identifying technique, computing statistics, and interpreting results. Associated data set accompanies the set purports to build a excel spreadsheet that discovers formula, illustrates the parameters, observes dynamic graphs and simulations that recodes, edits, validate, charts, and automatically links equations, data, and formulas to recalculate the data analysis. Excel recognizes statistical capability conjunction that carries out complex algorithms that implement correlated data columns. Excel quickly analyzes and interprets information filtered into a spreadsheet so the process is much easier then working out these formulas by hand. Excel spreadsheets create charts, graphs, and filters data all into one. Excel uses all of the basic mathematical operations such as addition, subtraction, division, and multiplication. Fractions and decimals are just as common for interpretation data into a excel spreadsheet. An advantage about excel is you can place any formula into the spreadsheet whether in ascending or descending order and using the same formula, it will automatically compute the answer for the next equation. Another advantage is if information is inaccurate, you can go back and check your work with just a click, unlike using y calculations or by hand you have to erase so much and start all over again, which could be time......

Words: 377 - Pages: 2

Premium Essay

Excel

...Operator: <= / Constraint entry: d9*32% 3. Laser Imaging machines (D7) should be greater than or equal to 28% of the total machines produced (d9*28%); also enter a constraint for less than or equal to 32% (d9*32%) 4. Magnes machines (D8) should be greater than or equal to 38% of the total machines produced (d9*38%); also enter a constraint for less than or equal to 42% 5. Number to make (D6:D8) must be whole units (use int) Verify that all parameters have been entered (set objective, changing cells and constraints), Solve and create an Answer Report. Resave your practice exam. This will still be a macro-enabled file. If you want feedback on your practice exam, please upload your file to Oncourse / Assignment 2 / Excel Case Practice link. On test day you will submit your completed exam to the Oncourse Assignment2 link....

Words: 1218 - Pages: 5

Premium Essay

Excel

...Terms Definitions The First step in creating an effective workseet is to make sure you __________. Understand what is required In Excel, a number can contain the charaters ________. 0 1 2 3 4 5 6 7 8 9 The cell being copied is called the source area (copy area). The range of cells recieving the copy is called the ________. receiving range You ________ a worksheet to emphasize certain entires and make the worksheet easier to read and understand. Format Pressing the _________ keyboard shorcut key(s) selects cell A1. CTRL + HOME How many chart types does Excel offer? 11 Which of the following keys is an alternative to double-clicking the cell to edit it? F2 Which of the following Opton buttons gives options for filling cells following a fill operation? Auto Fill Options A ________ cell in Excel has a numerical value of zero. Blank The ________ AutoComplete list contains those functiond that akohabetically match the letters you type following thr equal sign. Formula The most popular background color is _______. White ________ text often provides a strong visual appeal. Underlined To open the format cells dialog box with the Alignment sheet active, click the Format Cells ________. Dialog Box Launcher Which of the following is an extension of the fill patten Sunday, Tuesday? Thursday, Saturday, Monday Which of the following formula contains the absolute cell reference? =$B$4 A(n) _______ chart provides a simple way to show trends and variatons in a range of data...

Words: 423 - Pages: 2

Următor | Pet Sematary | NEW Boveda Butler Smart Humidor Sensor Monitor with One Step Calibration Kit