For example, with the known_x 1 values in B2:B13, known_x 2 values in C2:C13, and known_y values in D2:D13, you use the following formula to calculate trend: We’re also seeing more interest in less mainstream global cuisines as consumers seek adventure through international flavours and dishes. If global dishes are part of your menu, consider highlighting any traditional cooking styles or formats and design features to bring to life the authentic and rustic appeal of that cuisine. The popularity of retro and vintage themes remains also strong, especially for British and American cuisines – see our Retro Love trend. Operators are demonstrating rustic and rural charm through food and drink in several ways. Consumers’ favourites are being given a rustic twist with the use of authentic cooking styles and ingredients. Hand-made pasta, clay oven-baked pizzas, and artisan sourdough lunch items are just a few examples of increasingly popular menu items trending in the out of home market. When used for time series forecasting, both functions produce the same linear trend/ forecast because their calculations are based on the same equation.

Sustainability is another area that has come out strong but she cautions that we need to distinguish between truly green fashion and greenwashing. Circular fashion is a key word here but the industry needs to take care not only to end up with niche products at high prices. For her, only “vintage mania” is really circular. Being in Turkey, Catapano points to the country’s important roots in artisanal goods. “We need to rediscover our roots and handicrafts,” she says. She also points to the fact that trends have gotten ever shorter life spans - so called micro-trends like giant platform shoes, for example, barely make it a season. A trendline is commonly used to observe the general trend in your current data as well as project future data movements. To draw the trendline, select the sales and trend values (B1:C13) and make a line chart ( Insert tab > Charts group > Line or Area Chart). Please take a look at the screenshot below and compare the results returned by the following formulas:

Woke up like this

Courtesy of Rokh; Courtesy of Bottega Veneta; Courtesy of Versace; Courtesy of Ferragamo; Courtesy of Schiaparelli; Courtesy of Nina Ricci; Courtesy of Zimmermann You can calculate moving average manually with your own formulas or have Excel make a trendline for you automatically. In situation when you have two or more sets of independent x values, enter them in separate columns, and supply that entire range to the known_x's argument of the TREND fucntion. Const (optional) - a logical value specifying how the constant a in the equation y = bx + a should be calculated.

The “Craftwed Workwear” sub-theme emphasises denims and workwear while “Future Classics” goes for quirky a quirky look. “Horticool” stresses the connection to nature while “Outdoor Prep” is a take on the active sport world.

For this, we extend our time series with a few more month numbers and do trend projection by using this formula:

Courtesy of Alexander McQueen; Courtesy of Ann Demeulemeester; Courtesy of Givenchy; Courtesy of Versace As shown in the image below, the results of the trendline equation are perfectly in line with the numbers returned by the FORECAST and TREND formulas:

Executive suite

At first sight, the syntax of the TREND function might seem excessively complicated, but the following examples will make things a lot easier. TREND formula for time series trend analysis in Excel As the result, you have both the numeric values for the line of best fit returned by the formula and a visual representation of those values in a graph: Maxi hemlines have been a key trend this season and one that we think will really resonate with the Browns customer," shares Gramston. "We've seen both new-gen and super-brand designers move away from micro lengths to a more refined evening look, pairing fitted maxi-length dresses and skirts with floor-sweeping, tailored outerwear. Alaïa's rich chocolate-brown interpretation, the sheer long dresses from Blumarine and Nensi Dojaka and Diesel's double-denim-skirt-and-long-coat combination were some of our favourite exaggerated silhouettes from the runway."