Inferential Statistics Project  Project #2  This project gives you the chance to use the statistical techniques and concepts covered in Chapters 7-9, and Chapter 14.  Overview: The U.S. Department of Agriculture maintains a nutrient database for 100 nutrients of over 7300 foods. As part of this assignment, there is an Excel file in Canvas of cereal data from the 2004 USDA National Nutrient Database for Standard Reference, Release 17. * The dataset contains the fat, calorie, carbohydrate, fiber, and sugar data for all 278 cereal items in the nutrient database (at that time) that contain standard serving size information. From this data, you will ESTIMATE a population mean and determine an appropriate sample size. With the help of Excel, you can then take a random sample, test a hypothesis, calculate a confidence interval, and compare the results with the actual population data. You will also investigate the correlation between fat and calories.  Data Collection: In the files library in Canvas and attached to the assignment writeup is the Excel file for this project. It is called “Copy of cereal_usda_data_stat_proj2.xls”. Although the file can be considered a population, you MUST NOT use it in its entirety until part 4! POPULATION DATA IS ONLY TO BE USED FOR PART 4.  Optional Data Analysis: You may choose to analyze data of your choice under the following conditions:  ? You must pre-approve your data selection with the instructor.  ? The population should contain between 300-1000 observations.  ? Data for at least two different variables must be available for correlation analysis.  ? The data must be accessible to the instructor electronically (from any data source, including data entry by yourself).  Project Requirements  ? Project Elements: There are 5 parts to the project and they must be done in order! Label each part as you would a multiple part homework problem, example 1a)  1. Take a guess a. Begin with a visual review of data in the fat, calorie, carbohydrate, fiber, or sugar columns. Estimate the population mean for ONE of these variables. Do this without using a calculator or any Excel formula or function. You may only scan the date file visually in this step. State the variable name, your estimated mean, and describe how you arrived at it.  * Reference: U.S. Department of Agriculture, Agricultural Research Service. 2004. USDA National Nutrient Database for Standard Reference, Release 17. Nutrient Data Laboratory Home Page, http://www.nal.usda.gov/fnic/foodcomp GBS221 Bulriss  2. Construct a hypothesis test (and test with an appropriate sample size) a. State the hypotheses in mathematical and written terms.  b. Specify your chosen level of significance and state why you chose it.  c. Determine an appropriate sample size  d. State which form of the hypothesis test you will use & why. (Z or t, 1or 2 tail)  e. Calculate the Critical Value.  f. Use Excel to select a random sample. Be sure to document, in detail, your process for selecting the sample. Run Excel’s Descriptive Statistics on the sample. Include your random sample and descriptive statistics as an attachment to the project.  g. Calculate your test statistic, p-value, and state your conclusion.  a. Estimate the population mean for your variable using your sample data.  b. Comment on the estimate for your population mean.  c. Construct a confidence interval of your choice and interpret the results.  a. Compute the population mean and standard deviation using Excel’s descriptive statistics and compare them with the mean and standard deviation of your sample that you got in part 2f. Comment on the comparison.  b. Compare the population mean with your confidence interval from 3c and comment on the comparison.  a. Specify which is the independent variable and which is the dependent variable.  b. Write down what you think the relationship is between the two variables. What do you believe regarding the strength of the correlation? (Is it strong or weak, positive, or negative?)  c. Prepare a scatter diagram and least squares trend line, using your sample data. Compute the coefficient of correlation (r) and the coefficient of determination (r2). Refer to instructions in the files library in Canvas titled “Using Excel Chart Tools to Create a Scatter Diagram and Determine Regression Line”.  d. Interpret your results and compare them to what you expected.  Base your hypothesis test on your ESTIMATED population mean in Step 1 above.  ? When you determine sample size, use the method outlined in Section 8.3 of the text. You must decide what Z (confidence level) to use, the allowable error, and how to estimate the standard deviation (refer to page 384 for ways of estimating the standard deviation). Show how you calculated the sample size (show formula), and explain how/why you chose the values you used for Z, e, and ?.  3. Construct a confidence interval  4. Compute the population mean and standard deviation  5. Use simple linear regression on the random variables of fat and calories   

Your book talks about the "Scope Triangle" or the Iron Triangle.  Question 1: Your book addresses six areas that are part of the iron triangle -  Describe each of the areas included in the iron triangle Of the six which areas do you feel are the most important and why?  Question 2: You are managing a project and your sponsor has given the following constraints: The project must be completed in 2 months The project must include 7 core pieces of scope The project must stay within 1 million dollars What concerns do you have with the three constraints above and how do you proceed?   

ROE and DuPont analysis Step 1: Read the articles. These articles contain examples of using DuPont formula to analyze ROE. You will be using these example to answer the questions listed at the bottom of the topic description. How Did Deltic Timber Corporation's (DEL) 3.41% ROE Fare Against The Industry? – By Liz Campbell Simply Wall St. October 5, 2017 https://finance.yahoo.com/news/did-deltic-timber-corporation-del-113618019.html 2)      With A Recent ROE Of 3.33%, Can Glen Burnie Bancorp (GLBZ) Catch Up To Its Industry?- By Brent Freeman Simply Wall St. October 5, 2017 https://finance.yahoo.com/news/recent-roe-3-33-glen-195619168.html 3)      What You Must Know About Continental Materials Corporation's (CUO) Return on Equity- By Bernadette Hatcher Simply Wall St. October 5, 2017 https://finance.yahoo.com/news/must-know-continental-materials-corporation-180614863.html Step 2: Answer all discussion questions. You must use the company assigned for you for the project and one of its peer competitor. For this discussion you will get financial information using www.morningstar.com website. Type the stock symbol in the search window. This is the window just below the title MORNINGSTAR on the top of the screen. Once you have your company page, click on Key Ratios. Click on Full Key Ratios Data . ROE and it's components for DuPont formula can be found under Profitability. Debt/equity ratio can be found under Key Ratios – Financial Health. To get the list of competitors now you need to click on Analysis - and click on Competitors. Your assignment: Please also note that your answers should be written in your own words. Don't use quotes from the articles.  You are expected to make your own contribution in a main topic as well as respond with value added comments to at least two of your classmates as well as to your instructor. In your initial response to the topic you have to answer all questions. Find ROE, Net profit margin (listed as net margin), asset turnover, financial leverage for the last three years for your company. You also may use debt/equity ratio in your analysis. Find ROE, Net profit margin (listed as net margin), asset turnover, financial leverage for the last year for its major peer competitor. You also may use debt/equity ratio of peer competitor in your analysis. Has the company's ROE changed over the last three years? What was the main factor that influenced this change? Compare the ratios of you company to the peer competitor. If the management of the company would like to improve their return on equity, what should the management of the company do?  Reflection – the students also should include a paragraph in the initial response in their own words reflecting on specifically what they learned from the assignment and how they think they could apply what they learned in the workplace.