Recent orders

WalMart Sales of Boxed Foods within the Dry Goods Dept 2002-2003

MATH.1220

Management Calculus

Project #1

WalMart Sales of Boxed Foods within the Dry Goods Dept 2002-2003

The following items are a guide for responses to be addressed in project one. Note that WalMart’s fiscal year starts the first week of February. This means that when analyzing the data, week 26 is actually week 30 (26+4 weeks for January) in 2002 or the end of July 2002. Also, week 52 is actually week 4 (52+4 weeks for January 2002 minus 52 weeks for 2002) in 2003 or the end of January 2003. Outliers (extreme values) are present in the data and can distort modeling results. As an example, spikes in sales (revenue) at weeks 28-30 occurs in weeks 32-34 (28+4 and 30+4) which represent mid to late August 2002. Another spike at week 58 week is actually week 10 in 2003 (58+4 weeks for January 2002 minus 52 weeks for 2002). This corresponds to sales for early March 2003. The question is whether these spikes are due to special events or holiday periods, or are perhaps due to restocking and stock availability.

All projects must be printed on 8.5×11 paper in a word document with imbedded Excel graphs. No electronic copies or handwritten ones will be accepted. All content must be printed – no handwritten mathematics, graphs, labels, etc. All projects must be stapled.

The final project report is to be an individual effort. Collaboration during the report development is acceptable as part of the learning process.

When doing your least squares modeling of the data, don’t forget to generate the model (linear or quadratic) and then remove outliers (extreme values causing spikes in the data) and rerun the model. The results should improve with better R2 values. Discuss what outliers were removed and why.

Generate supporting Excel graphs (use scatter plots) to answer the following questions for the given data:

Identify spikes (outliers) in the data where extreme sales values occur and correlate these spikes with actual calendar dates in 2002 or 2003 and with events that may occur during these periods.

Modeling the data linearly –

Generate a linear model for this data by choosing two points.

Generate a least squares linear regression model for this data.

How good is this regression model? Output and discuss the R2 value.

What are the marginal sales (derivative, i.e. rate of change) for this department using

the linear model with two data points and the regression model?

Compare the two models. Which do you feel is better?

Remove appropriate outliers as you deem necessary and rerun the linear regression

model. What is the marginal sales and discuss improvements.

Modeling the data quadratically –

Generate a quadratic model for this data. Also output and discuss the R2 value.

What are the marginal sales for this department using this model?

Calculate the model generated relative max/min value. Show backup analytical work.

Compare actual and model generated relative max/min value.

e. Remove outliers and rerun the quadratic least squares model. What is the marginal sales and discuss improvements.

4. Comparing models

Based on all models run, which model do you feel best predicts future trends? Explain

your rationale.

Based on the model selected, what type of seasonal adjustments, if any, would be

required to meet customer needs?

INCLUDEPICTURE “/var/folders/sj/7_tfwmrj25j4t9l38_4mgww00000gn/T/com.microsoft.Word/WebArchiveCopyPasteTempFiles/page1image685553920” * MERGEFORMATINET

to a single pdf file if you choose. Copy and paste your Excel files to your Word

INCLUDEPICTURE “/var/folders/sj/7_tfwmrj25j4t9l38_4mgww00000gn/T/com.microsoft.Word/WebArchiveCopyPasteTempFiles/page1image685471472” * MERGEFORMATINET

document. Send me a pdf or MS Word version of your final project.

INCLUDEPICTURE “/var/folders/sj/7_tfwmrj25j4t9l38_4mgww00000gn/T/com.microsoft.Word/WebArchiveCopyPasteTempFiles/page1image684757264” * MERGEFORMATINET

When doing your least squares modeling of the data, don’t forget to generate the model

(linear or quadratic) and then remove outliers (extreme values causing spikes in the

data) and rerun the model. The results should improve with better R^2 values. Discuss

what outliers were removed and why.

The file project 1 online requirements lists details for what is to be done. Write your

report as if you are a consultant to WalMart in an expository format. The Excel cheat

sheet file provides contains brief steps for Excel 2016 to generate your Excel charts,

add trendlines, set up headings and axes titles, reset min and max values for axes, and

move the chart to a separate page. You should find it useful. The sample scattergram

project 1 for online pdf file exhibits what your scattergram should look like. The Boxed

Foods goods data Excel file provides the data to work with.

Excel 2016 cheat sheet

The following should guide you through creating charts for Excel 2016. Start by referencing your text (p.635-636).

Enter data with headingsHighlight the headings and data, insert tab->select scattergram (use entry for points in the top left or use the entry for straight lines and markers in the 2nd row far right)Right click any point in the graph->select add trendline, select: linear, display equation on chart, display R-squared->closeUnder chart tools in the upper right ( click anywhere on the chart in empty space if chart tools doesn’t appear)->click on layout->chart title->enter “Boxed Foods”, then axes titles->horizontal- >enter “weeks”, then axes titles->vertical->enter “sales’Right click any value on the horizontal axis->select format axis->reset the min and max values as desiredRight click on the chart in empty space ->select “move chart”->click on new sheet to get a separate page for the chart. Be sure to save your file!

Note: If the formula->font->change the size to a larger size as needed->ok.

it is necessary to increase the text size of your Excel trendline generated formula, right click on

[A.] Project – Analysis & Requirements

1. Analyze the given Walmart Boxed Foods 2002-2003 data set that is part of the Dry Goods department. Correlate the major spikes of the data with that of the major holiday periods cited in the 2002-2003 calendar year.Identify holiday periods or special events that cause the spikes in the data. Present your analysis result in a table format showing:

Wks-No, Spike-Sales-Value, and Calendar period

2. Generate linear and quadratic models using regression for the data set. Present your plots with appropriate titles, the axes labeled and showing the model equation and R2 value. Refer to the project requirements file for detailed instructions to be followed.

It seems as though every family has a set of core values that they uphold and pass down to future generations.

Mary Lou Reyes

Personal Statement

L35019514

It seems as though every family has a set of core values that they uphold and pass down to future generations. For my family, it was traditionalism. Growing up, my household was very traditional. My mother took on the role as the homemaker while my father went out and worked to provide for our family. Furthermore, my sisters and I were conditioned to always act like a “lady” and to live a good Catholic life. This included consistently attending church, praying every morning, meal, and night, as well as holding ourselves virtuously.

In accordance with the Lord and my family, I did exactly that. I grew up to have a very traditional lifestyle. I married my high school sweetheart, gave birth to my beautiful daughter, and followed every step that I had seen the women in my family take. Unfortunately, this was not the path the Lord intended and I knew deep down that I was destined to be more than just a homemaker. Going forward, I had to set a new example of how a woman should act so I could teach my daughter to not limit herself to the traditional values that were once set in stone within my family. At this point, I decided to go beyond these traditional expectations and expand my education. Not only did I obtain several certifications and my Associate’s degree, I also earned my Bachelor’s degree in Justice Administration at Wayland Baptist University.

As a newly divorced, single mother I had to work twice as hard as those around me. Unlike younger students, I did not have the time or leniency to make mistakes or slack off. I had to pay extra attention, ask all the right questions, and work nonstop in order to ensure my success as a nontraditional student. Here is where I saw my once very traditional lifestyle shift into a nontraditional one. Ultimately, I knew the road ahead would not be a smooth ride, but rather the most challenging adventure of my life.

After 25 years of experience in the legal field, I realized something is missing. My law degree! While working as a Legal Secretary and Paralegal for several law firms, I discovered that I want to do more. Not only do I want to show my daughter that anything is possible regardless of the circumstances, I want to be the fighting voice of those who cannot help themselves. Unfortunately, the field of law is difficult to interpret and not everyone has the means of doing so. With that said, I plan to use my law degree to fight for justice and provide assistance to those who need it most.

As a nontraditional student, I strongly believe I would bring an interesting perspective to Texas Tech University School of Law. Not only would I act as living proof that there is no age limit or timeline when it comes to success, I would show other Latina women that anything is possible if you believe in yourself and work hard. Through this prestigious law school, I hope to continue to stray away from a traditional lifestyle, set an example for my beautiful daughter, and achieve my dreams of becoming a lawyer so I can give back to the community.

Research plan

Marsadie Brown

Monica Swindle

GS 3300-001

April 21st, 2019

Research plan

So far in my research, I’ve learned that society really does put a negative impact on elders, they make it seem as if elders are really a burden to society and should only act a certain way. From media they show that elders are to only act in a monogamous way and that they are all heterosexual. Which with the newer generation of elders and some older generations we all know that not all elders are heterosexual. Which this answers a research question that I originally had “Why is everything sexualized? For example, Tv ads separating deodorant” I learned not only from my research, but analyzing life and society that, everything is sexualized because we are sexual beings. Without gender coming into play because, gender is what was formed by society and gender norms and roles. We are automatically sexual, it is in our nature, it’s a part of our biology and chemistry. Women naturally reproduce, men naturally have a penis, adolescence boys automatically go through puberty and begin to regulate hormones, so they can come in contact to eventually mate with a woman and reproduce. This is natural, these are physical/mental experiences that all humans go through and we continue to go through for the rest of our life’s until of course old age.

Another, one of my initial research questions which was “The older we get does our sex drive die down or does it slow down?” and from “How important is sex in later life?” I’ve found numerous of qualitative research study’s that was done and, one of the study’s was a sample of people aged 50-92 and it stated that some aspect of sex is important to their lives and had a sexual partner. They were ranked by “Very” or “extremely” in importance during this sample, this goes to show that sex is an important necessity to maintain elder’s everyday wellbeing. And, these statistics not only goes for elders, but of course younger adults.

Lastly, in my research, I had originally aimed to found out “why does society put so much emphasis on elders not having sex” but, this question really wasn’t a good research question. It is more so because again, society feels that elders shouldn’t behave a certain way that basically elders should just rot and die. But, majority of seniors are living their best years, elders take their later years in life as reflective, they are happy to make it thus far. And, If they still have family, family is what they cherish the most and of course if they can go out and experience the world around them.

The focus of the research is to address the general public about the stigmas surrounding ageing and sexuality. Sexuality is lifelong and it is important to understand societies views and biases concerning older adults and their expression of sexuality. In my course project which will be a traditional research paper, I will aim to analyze real life sexual experiences surrounding ageing and sexuality that goes throughout the human body as we age. I want to dig more into and explain my findings in my research on how different elders are sexually active. Why does society have these biases towards elders on their ageing, specifically sexual activities and the changes elderly men and women go through as they age? I want to aim in my research to let the audience know that elders and how they age, it is okay. Nothing is wrong with a seventy-five year old still driving a car and being healthier than someone in their 20’s. I want my audience to know that everyone ages and we are ageing currently and soon someday if we don’t act on maintaining our bodies then we could initially end up ageing in a negative way and not a positive way. Annotated Bibliography

Gatling, Margaret et al. “Sex After 60? You’ve Got To Be Joking! Senior Sexuality In Comedy Film”. Journal Of Aging Studies, vol 40, 2017, pp. 23-28. Elsevier BV, doi:10.1016/j.jaging.2016.12.004. Accessed 13 Apr 2019.

The study done by Margaret et al. (2017) addresses the fact that cinema and film has not been representative of sex and sexual lives of older adults, specifically those who are 60 and older. The writers analyze four recent (from the year 1993 onwards) films where “senior sexuality” is represented. They address the media represented problematic idea that seniors are monogamous, heterosexual, and do not engage in their sexual life. They go on to discuss that sometimes films chose to break the stigma and represent senior sexuality in a more natural sense.

This connects to the course material in the sense that it analyzes representation of sexuality as part of society and sociology. It provides insight into how society views sexuality in older adults and the stigma surrounding the topic.

This source allows me to see how sexuality can be destigmatized through the use of media. Additionally, I can use this source to present the viewpoints of various ages towards senior sexuality representation in cinema and other arts.

González, César. “Age-Graded Sexualities: The Struggles Of Our Ageing Body”. Sexuality & Culture, vol 11, no. 4, 2007, pp. 31-47. Springer Nature, doi:10.1007/s12119-007-9011-9. Accessed 13 Apr 2019.

The article written by Gonzalez (2019) addresses the topic of the physical aspect of aging (body-wise) and sexuality and perceived by society. The symbolic aspect of the body as it ages with years is intrinsically interview with the sexuality and social concepts of what it means to be sexual and in the body which one is in. The concepts of age-grading are discussed, which is a way to categorize the state in which a body is in in regard to its age, and the boundaries and constricts it has.

Gonzalez goes on to discuss how age-grading has influenced sexuality through impacting sexual ideologies such as sex, gender and reproduction, and the life cycle which is relevant to the sociological aspect of sexuality discussed in class.

This source provides insight into the possibilities of approaching sexuality between people of an older age. It also provides information about the first-person experience when it comes to relationships and sex lives between older adults.

Gott, Merryn, and Sharron Hinchliff. “How Important Is Sex In Later Life? The Views Of Older People”. Social Science & Medicine, vol 56, no. 8, 2003, pp. 1617-1628. Elsevier BV, doi:10.1016/s0277-9536(02)00180-6.

Gott and Hinchliff (2003) provide an overview of both quantitative and qualitative data of perspectives on the role sex and sexuality plays in the lives of older people. Data such as quality of life measurement and an interview process were done to compile a sample of 69 individuals aged 50-92. They have found that individuals who stated that at least one aspect of sex was an important part of their lives also had a sexual partner. These individuals ranked importance as “very” or “extremely” representing the intensity of importance. Participants also expressed concerns towards expressing sexuality due to the social and cultural barriers.

This provides the relevant insight into the way society interacts with elder individuals and the role they play in society. Additionally, it also relates to the way’s sexuality plays in the overall wellbeing of a person.

This article is relevant to my research in that it is able to provide analytical data into respective of sexuality in the lives of elder people. Statistical analysis makes this data reliable and factual.

Potts, Annie et al. “‘Sex For Life’? Men’s Counter-Stories On ‘Erectile Dysfunction’, Male Sexuality And Ageing”. Sociology Of Health And Illness, vol 28, no. 3, 2006, pp. 306-329. Wiley, doi:10.1111/j.1467-9566.2006.00494.x. Accessed 13 Apr 2019.

With the introduction of medications which address such conditions as erectile dysfunction, the world of sexuality in older adults (and those struggling with said issue) has been forever altered. Potts (2006) discusses the ways in which society and the community of med has changed its perspective towards ageing and sexuality. The author addresses the ways in which male sexuality in older adults has shifted perspectives.

This is relevant to the course material in the way that it presents societal views of individuals who might feel incompetent in some aspects of their lives. Incompetency can breed insecurities and a lower self-esteem which makes life less satisfactory.

This article shows the opinions of various people when it comes to using aids to sustain their sexual lives into their older adulthood. Examining the different perspectives provides insight into the research question at hand.

Ringa, Virginie et al. “Women’s Sexuality: From Aging To Social Representations”. The Journal Of Sexual Medicine, vol 10, no. 10, 2013, pp. 2399-2408. Elsevier BV, doi:10.1111/jsm.12267. Accessed 13 Apr 2019.

Research done by Ringa et al. (2013) examined the sexuality of women aged 45-55 years old as they go through the process of reaching menopause. Considering that previous studies show that many women continue to be sexually active after menopause, Ringa et al. wanted to see what other factors besides hormones play a role in this demographic’s sexuality. They examined three groups of women: postmenopausal women who are using hormones and those who are not, and a group of premenopausal women. The researchers have found that all groups of women expressed importance of sexuality in their lives. Additionally, all groups of women did not differ in sexual practice, satisfaction, and dysfunction when it came to their sexuality.

Sexuality plays an important role in a person’s life regardless of their age. This article represents that even after biological changes, a woman still perceives sexuality as an important part of a healthy and satisfying life, much like discussed in the course material regarding sexuality in society.

This article provides insights into the significance of sexuality as it relates to menopause. Although many perceive that menopause can reduce sexual drive, this article shows otherwise.

Thompson, Ashley E. et al. “Young Adults’ Implicit And Explicit Attitudes Towards The Sexuality Of Older Adults”. Canadian Journal On Aging / La Revue Canadienne Du Vieillissement, vol 33, no. 03, 2014, pp. 259-270. Cambridge University Press (CUP), doi:10.1017/s0714980814000208. Accessed 13 Apr 2019.

When addressing the stigma and societal notions surrounding sexuality in old age, it is important and beneficial to address the ways of how the youth sees it. Little support exists for the expression of sexuality in older individuals, in addition to lack of representation and education. Thompson et al. (2014) analyzed and compared the ways in which young adults view older adult sexuality and their overall attitudes towards the topic. A total of 180 individuals (18-24 years old) filled out self-report surveys and data was analyzed. The researchers found that overall attitudes towards senior sexuality was positive. However, there existed a bias towards favoring younger adults to older adults in expressing sexuality, and general sexuality to any specific activities.

This article presents the stigma surrounding sexuality in elder people as seen my young adults. It shows that sometimes what is said does not always align with the societal norms. Many people may adjust to the popular opinion and negate their honest opinion about the subject.

This article provides useful insight into the way young people see adult sexuality. By addressing their concerns, the stigma around senior sexuality can be adjusted and lifted, as well as publicly and societally accepted as normal and healthy.

Woodward, Kathleen. “Performing age, performing gender.” NWSA Journal (2006): 162-189.

The following article discusses the ways the older female body is represented in mass media and the beauty standards surrounding older women. Woodward discusses how the older body beauty standards are skewed to steer more towards a youthful look and how mass media fails to represent the way the female body ages with time.

This is relevant to the discussed class material regarding ageism which is prevalent in the American culture and overall. The lack of representation in mass media and the way society dictates beauty standards reflects on the way people live their lives.

This article is able to show the ageism approach to the female body and the way it impacts sexuality in older people. It is able to show the negative impacts societal beauty standards have on sexuality in elders.