The growth of supermarkets in most populated cities are increasing and market competitions are also high. The dataset is one of the historical sales of supermarket company which has recorded in 3 different branches for 3 months data. Predictive data analytics methods are easy to apply with this dataset. please fund attachment of data set

SHEET1 

Apply the concepts covered during the week( text function( Trim, left, right, clean, find, search ) to a use case with real-world data for a business or organization.

Provide a brief explanation of your data, the business or organization, and the use case. 

• Provide an overview of your      data, business/organization, and use case.
• Articulate what Excel functions      you have used and apply it to the dataset to demonstrate it.

SHEET 2

Apply the concepts covered during the week( text function( countif, countifs, count.counta and count black ) to a use case with real-world data for a business or organization.

Provide a brief explanation of your data, the business or organization, and the use case. 

• Provide an overview of your data, business/organization, and use case.

• Articulate what Excel functions you have used and apply it to the dataset to demonstrate it.

SHEET3

Apply the concepts covered during the week( text function( Sumif, averageif, sumifs and averageifs) to a use case with real-world data for a business or organization.

Provide a brief explanation of your data, the business or organization, and the use case. 

• Provide an overview of your data, business/organization, and use case.

• Articulate what Excel functions you have used and apply it to the dataset to demonstrate it.

 Purpose 

This assignment provides an opportunity to develop, evaluate, and apply bivariate and multivariate linear regression models.

Resources: Attached Data File Excel Document

Instructions: 

The Excel file for this assignment contains a database with information about the tax assessment value assigned to medical office buildings in a city. The following is a list of the variables in the database:

• FloorArea: square feet of floor space
• Offices: number of offices in the building
• Entrances: number of customer entrances
• Age: age of the building (years)
• AssessedValue: tax assessment value (thousands of dollars)

Use the data to construct a model that predicts the tax assessment value assigned to medical office buildings with specific characteristics.

• Construct a scatter plot in Excel with FloorArea as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables?
• Use Excel’s Analysis ToolPak to conduct a regression analysis of FloorArea and AssessmentValue. Is FloorArea a significant predictor of AssessmentValue?
• Construct a scatter plot in Excel with Age as the independent variable and AssessmentValue as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables?
• Use Excel’s Analysis ToolPak to conduct a regression analysis of Age and Assessment Value. Is Age a significant predictor of AssessmentValue?

Construct a multiple regression model.

• Use Excel’s Analysis ToolPak to conduct a regression analysis with AssessmentValue as the dependent variable and FloorArea, Offices, Entrances, and Age as independent variables. What is the overall fit r^2? What is the adjusted r^2?
• Which predictors are considered significant if we work with α=0.05? Which predictors can be eliminated?
• What is the final model if we only use FloorArea and Offices as predictors?
• Suppose our final model is:
• AssessedValue = 115.9 + 0.26 x FloorArea + 78.34 x Offices
• What wouldbe the assessed value of a medical office building with a floor area of 3500 sq. ft., 2 offices, that was built 15 years ago? Is this assessed value consistent with what appears in the database?

Submit your assignment. 

 You are the fire marshal in your jurisdiction. The fire chief asks you to put together a report highlighting the impact and return on investment the fire prevention division has on the safety of the community. The chief has asked that you submit your report in writing so that it can be reviewed and discussed at the next staff meeting. With the current budget constraints, several members of the city council feel like there are more important areas and programs that need funding. If your report is approved, it will be presented at the next city council meeting. 

• Explain the rationale and benefit of inspection and code enforcement policies and general fire safety provisions as methods of fire protection.
• Examine the interrelationship of regulatory practices in fire prevention by identifying how inspection and code enforcement activities tie into the success of public education programs, plans review, and fire investigations on community resilience.
• Discuss the importance of general fire safety provisions for occupied buildings, including fire suppression systems, and characteristics of unsafe structures in your community.
• Identify the short-term and long-term benefits to your community through investments, including the practice of fire-resistant materials.
• Provide an overview of the fire prevention division and activities, including professional development process for code enforcement practitioners.
• Provide some background demographics of your community related to the project (i.e., common occupancies, high call volume areas, types of calls, fire activity, etc.), including the building code development and modification process.
• Identify benefits of inspection and code enforcement for the community and the organization versus the cost of performance.

During week 3, you completed a detailed food and fluid log for 2 days and analyzed your intake using the MyPlate application to assess how well you met dietary guidelines for macronutrients. This week, you will be using the same food and beverage logs to assess how well your vitamin intake meets dietary recommendations. SEE ATTACHMENT

Analyze your nutrient intake using the MyFitnessPal Tracker (Links to an external site.)Links to an external site.. Enter the information from the reports you generate into your Vitamin Tracking Chart. Make sure to include this chart in your lab write up!

Reflection Questions: (Add your responses at the end of the Tracking Chart)

1. For which vitamins did you meet or exceed the recommended daily intake level? What enabled you to meet dietary recommendations for these vitamins?
2. For which vitamins were you below the recommended daily intake level if any? Why do you think you failed to meet RDI levels for these vitamins?
3. What specific changes can you make to your diet to increase your intake for each of the vitamins that you were deficient in? (Make sure that you break down this response vitamin by vitamin, rather than providing a generic response.)
4. What did you learn from completing this lab?

Make sure you respond to all the questions THOROUGHLY. Include the results from your MyPlate analysis, as well as the table above in your write up. Include references for all sources used.

Week 13 – Day 1 – Assignment 2 – Peer Reviews – Due Date: 5/23

You will be assigned 1 of your peers’ Chapter 4 to provide a peer review. Please read the following instructions and answer the questions that follow. I attached the chapter that you will review to your individual assignment submission box. Let me know if you can’t access it.

Peer Review Instructions for Writing Assignment
Reviewer:
Instructions
Read each person’s Chapter (attached) twice. In the first reading, just get the feel of the essay’s organization and points—make large-scale comments if they occur to you as you read.
In the second reading, start to fine-tune your feedback.
Make comments on the draft, and then write some feedback on this sheet (use complete
sentences and be as thorough as you can).
Questions/Comments to Consider:
1. Do you have any concerns about the writer’s submission?
2. From the findings, are you able to identify the problem? Solution – if any? Explain.
3. Organization and transitions: Look through the essay and take note of the way the writer moves
from point to point, from one paragraph to the next. Do major ideas seem to be organized in a
logical way?
4. Support: Identify any areas in the essay that seem to need greater support in concrete evidence or
more explanation. Also, point out places where the writer needs to clarify how the evidence given.
supports the argument.
5. Grammar/Spelling/Mechanics: Identify patterns you see in grammar, punctuation, and spelling
errors. Point to at least one example of each pattern in the draft. 

Chapter 4I went to 3 different gym locations in Los Angeles and asked 100 men and 100 women these 3 questions. “Do you ever feel uncomfortable working out at the gym? How often do you come to the gym? Would you prefer to workout at a gender segregated gym? 12% of men and 67% of women said that they have felt uncomfortable working out at the gym? 32% of men said they come to the gym 3 times a week, and 63% of women said they come to the gym once a week. 2% of men and 29% of women said that they would prefer to workout at a gender segregated gym. This shows a trend that tells me a few things. One thing I noticed is that the high percent of women feeling uncomfortable at the gym may be directly correlated to the lackof frequency throughout the week at the gym for women. Only 15% of women said that they go to the gym more than twice a week. Also, thelow percentage of both men and women that would prefer gender segregated gyms has a particular connotation to it as well. The fact that almost all the people questioned have never experienced a gender segregated gym and also the fact that the idea of seeing great bodies of the opposite sex is part of motivation to come to the gym in general for both men and women. Most women said they feel that the attention they get from the men at the gym seems aggressive, but they still appreciate some attention, however. Men also enjoy having the women to motivate them to showcase their strength atthe gym but also a substantial motivator as well.This tell me that the gym culture with both me and women sharing thatspace with boosted testosterone and skintight clothing teasing the mind of the lurkers, that sexual harassment is normal in this environment. Out of the 100 women questioned 73% of them have said that they have been harassed or even stalked by someone at the gym. This tells me that there needs to be more options for these women to go workout and not have to just hope they don’t get pressured by a overly aggressive creep at the gym. There’s a need fora chain of commercial women only gyms that women can feel comfortable in. Not only a safe haven away from potential harassmentfrom these overly aggressive men but also a place where the shy can come improve their body and not feel embarrassed because men are around.  Also a place they don’t have to feel intimidated by these 

stereotypes about how lifting weights will make you look like a man, but they will see other women that are beautiful and strong and realizethat there are tons of benefits in weightlifting and it will not make you look like a man. Learn tips from female fitness professionals and learnabout how fitness can help them with their pains throughout their menstrual cycle as well s stress relief. These are just some examples of things that women will be more open to learning without the intimidations of men being around preventing that.