How To Run A Multiple Regression In Excel And Actually Understand The Results

Sara Silverstein

Updated 14 October 2014 at 7:33 am

It’s easy to run a regression in Excel. The output contains a ton of information but you only need to understand a few key data points to make sense of your regression.

You need the Analysis Toolpak add-in to run regressions. It comes with Excel but you may need to load it if you don’t see Data Analysis under the Data toolbar. Click here to see how to install the add-in.

Produced by Sara Silverstein

Follow BI Video: On Facebook

Read more stories on Business Insider, Malaysian edition of the world’s fastest-growing business and technology news website.

The Telegraph
‘Loyal wingman’ fighter drones tested for first time in Britain
“Loyal wingman” fighter drones that will fly alongside British aircraft are a step closer to reality after the technology was successfully tested for the first time.
24m ago
People
“Call Her Daddy'”s Alex Cooper Models Her Wedding Night Lingerie in Instagram Reveal: See the Racy Look
Cooper wore a sexy lacy bodysuit from SKIMS' Wedding Shop collection after marrying Matt Kaplan in Mexico
2d ago
Malay Mail
Navy chopper crash: Police probe launched into hate comment on X
KUALA LUMPUR, April 25 — The police have opened an investigation into a hate comment in relation to the recent helicopte...
1d ago
Malay Mail
EPF announces account restructuring that lets contributors withdraw anytime
KUALA LUMPUR, April 25 — The Employees' Provident Fund (EPF) announced today a restructuring of its contributors account...
1d ago
InStyle
Prince Edward and Duchess Sophie Feel Disappointed by King Charles Royal Title "Snub"
The "chosen ones" are reportedly sad they didn't get new roles after Prince William and Kate Middleton's latest appointments.
1d ago
The Telegraph
Horse trainer accused of rape and murder found dead at home
A horse trainer who was accused of the murder and rape of a showjumper he was in an “illicit relationship” with has been found dead before the second day of his trial was set to begin.
2d ago
The Telegraph
Russia has found the critical vulnerability in Nato’s American tanks
The arrival of the US M1A1 Abrams tanks in Ukraine was hailed as a turning point in the war. Coming in at roughly $10 million a unit, the Nato stalwart was supposed to provide the armoured fist that would punch through the Russian lines. But tactics evolve quickly in warfare, and Russia’s use of surveillance and hunter-killer drones has led to heavy casualties for Ukraine’s tank fleets. This is alarming for NATO. If Russia has found critical vulnerabilities in our armour, our borders are beginni
4h ago
People
Joan Collins, 90, Wears Sheer, Embellished Top and Oversize Bow for London Date Night with Her Husband Percy Gibson
The couple, who wed in 2002, supported their friend Gabriela Peacock’s book launch at the Broadwick Soho
2d ago
People
TikToker Xandra Pohl Sizzles in Racy Bikinis in “Sports Illustrated Swimsuit” Rookie Shoot: ‘Been My Dream’
Pohl joins Brittany Mahomes and seven Swim Search finalists in the 2024 Rookie class in the magazine’s 60th-anniversary issue, out May
2d ago
HuffPost
Harrowing Video Shows A Black Man’s Last Words As Police Knelt On Him
The body camera footage shows police waiting about six minutes after Frank Tyson became unresponsive before starting CPR.
16h ago
Malay Mail
Rahim Thamby Chik says former Umno's Dewan Negara deputy president Mohamad Ali now in Bersatu
KUALA LUMPUR, April 25 — Parti Pribumi Bersatu Malaysia information committee member Tan Sri Abdul Rahim Thamby today cl...
2d ago
People
Prince William Shares Princess Charlotte's 'Favorite Joke' at the Moment, and It's a Total Classic!
"That’s the one I hear a lot at home at the moment," the Prince of Wales said of the knock-knock joke
1d ago
People
Claudia Schiffer Shouts Out Kylie Jenner's Vintage Bikini — and Shares Glam Photo Wearing the Same One in the '90s
Schiffer modeled the Chanel bikini on the runway and in the fashion house's ads
2d ago
Bloomberg
Chinese metal tycoon’s heir buys $62 million Singapore mansion
The daughter of a Chinese nickel billionaire purchased a multimillion-dollar mansion in Singapore, adding to the list of wealthy people seizing buying opportunities during the market lull.
1d ago
Malay Mail
Anti-graft group says ex-MP should pay for dumping expired rice, food aid at Temerloh dumpsite
KUALA LUMPUR, April 25 — The Center to Combat Corruption and Cronyism (C4 Center) today called on the government to hold...
2d ago
Malay Mail
Zambry: Pro-Israel professor's statement dangerous; there are better local professors than him
PUTRAJAYA, April 26 — Minister of Higher Education Datuk Seri Zambry Abd Kadir today lambasted controversial American ac...
12h ago
The Telegraph
Watch: Biden reads ‘pause’ aloud from teleprompter in latest speech blunder
Joe Biden has suffered an “Anchorman moment” after he read out a prompt to “pause” on his teleprompter to a baffled audience.
2d ago
Yahoo Life UK
Eating too many of these healthy foods could be harmful, expert warns
A nutritionist has warned against eating too many eggs, broccoli, and kale.
1d ago
AFP News
North Koreans in China vanish as border reopens
After fleeing famine in North Korea, Kim Cheol Ok laid low in China for decades -- until a doomed run for freedom got her sent back to her repressive homeland, her family says.She told her family she was being sent back to North Korea two hours later and was never heard from again.
2d ago
InStyle
Jennifer Lopez Won't Stop Wearing These Divisive Jeans
She's been spotted in them three times in the last two weeks.
18h ago

Latest stories