Anchoring - Revision history

imported>Doug Williamson: Remove surplus text.

2022-02-03T08:39:39Z

Remove surplus text.

← Older revision		Revision as of 08:39, 3 February 2022
Line 17:		Line 17:
	In financial modelling with spreadsheets, anchoring refers to cell references when they're copied around the spreadsheet.		In financial modelling with spreadsheets, anchoring refers to cell references when they're copied around the spreadsheet.

	Fully anchored cell references - for example '''$A$1''' in Excel - will stay as $A$1 wherever we copy them ~~around to~~ within the spreadsheet.		Fully anchored cell references - for example '''$A$1''' in Excel - will stay as $A$1 wherever we copy them within the spreadsheet.

imported>Doug Williamson: Layout.

2022-02-02T05:46:48Z

Layout.

← Older revision		Revision as of 05:46, 2 February 2022
Line 17:		Line 17:
	In financial modelling with spreadsheets, anchoring refers to cell references when they're copied around the spreadsheet.		In financial modelling with spreadsheets, anchoring refers to cell references when they're copied around the spreadsheet.

	Fully anchored cell references - for example $A$1 in Excel - will stay as $A$1 wherever we copy them around to within the spreadsheet.		Fully anchored cell references - for example '''$A$1''' in Excel - will stay as $A$1 wherever we copy them around to within the spreadsheet.


	This kind of cell reference is sometimes known as an absolute, fixed or dollarised reference.		This kind of cell reference is sometimes known as an absolute, fixed or dollarised reference.

	Contrasted with a standard relative cell reference - for example A1.		Contrasted with a standard relative cell reference - for example '''A1.'''

	Relative cell references are the default.		Relative cell references are the default.

imported>Doug Williamson: Add definition. Source: Linked pages

2022-02-02T05:41:21Z

Add definition. Source: Linked pages

← Older revision		Revision as of 05:41, 2 February 2022
Line 11:		Line 11:

	The reasonableness, or acceptability, of subsequent figures tends - wrongly - to be evaluated by reference to the earlier figure, rather than by objective criteria.		The reasonableness, or acceptability, of subsequent figures tends - wrongly - to be evaluated by reference to the earlier figure, rather than by objective criteria.


			2. ''Financial modelling - spreadsheets - construction - cell references.''

			In financial modelling with spreadsheets, anchoring refers to cell references when they're copied around the spreadsheet.

			Fully anchored cell references - for example $A$1 in Excel - will stay as $A$1 wherever we copy them around to within the spreadsheet.


			This kind of cell reference is sometimes known as an absolute, fixed or dollarised reference.

			Contrasted with a standard relative cell reference - for example A1.

			Relative cell references are the default.


	== See also ==		== See also ==
			* [[Absolute]]
	* [[Affinity bias]]		* [[Affinity bias]]
	* [[Bandwagon bias]]		* [[Bandwagon bias]]
Line 21:		Line 36:
	* [[Cognitive bias]]		* [[Cognitive bias]]
	* [[Confirmation bias]]		* [[Confirmation bias]]
			* [[Default]]
	* [[Default bias]]		* [[Default bias]]
	* [[Diversity]]		* [[Diversity]]
	* [[Dunning-Kruger effect]]		* [[Dunning-Kruger effect]]
	* [[Emotional intelligence]]		* [[Emotional intelligence]]
			* [[Excel]]
	* [[Executive coaching]]		* [[Executive coaching]]
			* [[Financial modelling]]
	* [[Hindsight bias]]		* [[Hindsight bias]]
	* [[Impostor syndrome]]		* [[Impostor syndrome]]
Line 32:		Line 50:
	* [[Optimism bias]]		* [[Optimism bias]]
	* [[Reactance bias]]		* [[Reactance bias]]
			* [[Relative]]
	* [[Self-investment bias]]		* [[Self-investment bias]]
	* [[Self-serving bias]]		* [[Self-serving bias]]
	* [[Social bias]]		* [[Social bias]]
	* [[Source bias]]		* [[Source bias]]
			* [[Spreadsheet]]
	* [[Status quo bias]]		* [[Status quo bias]]
	* [[Working effectively with others]]		* [[Working effectively with others]]

imported>Doug Williamson: Layout.

2022-02-02T04:48:56Z

Layout.

← Older revision		Revision as of 04:48, 2 February 2022
Line 1:		Line 1:
	''Behavioural skills - cognitive bias''.		1. ''Behavioural skills - cognitive bias''.

	The anchoring effect, or ''anchoring bias'', is a tendency in decision-making to place excessive importance on the first piece of information accessed.		The anchoring effect, or ''anchoring bias'', is a tendency in decision-making to place excessive importance on the first piece of information accessed.

imported>Doug Williamson: space

2021-05-13T10:27:24Z

space

← Older revision		Revision as of 10:27, 13 May 2021
Line 7:		Line 7:

	A common example is the first figure mentioned in a price negotiation.		A common example is the first figure mentioned in a price negotiation.

imported>Doug Williamson: Correct typo "initial".

2021-04-16T22:41:41Z

Correct typo "initial".

← Older revision		Revision as of 22:41, 16 April 2021
Line 3:		Line 3:
	The anchoring effect, or ''anchoring bias'', is a tendency in decision-making to place excessive importance on the first piece of information accessed.		The anchoring effect, or ''anchoring bias'', is a tendency in decision-making to place excessive importance on the first piece of information accessed.

	This ~~intial~~ piece of information is known as the ''anchor''.		This initial piece of information is known as the ''anchor''.

imported>Doug Williamson: Mend link.

2021-04-16T22:41:11Z

Mend link.

← Older revision		Revision as of 22:41, 16 April 2021
Line 32:		Line 32:
	* [[Reactance bias]]		* [[Reactance bias]]
	* [[Self-investment bias]]		* [[Self-investment bias]]
	* [[Self serving bias]]		* [[Self-serving bias]]
	* [[Social bias]]		* [[Social bias]]
	* [[Source bias]]		* [[Source bias]]

imported>Doug Williamson: Create page. Source: Harvard webpage https://www.pon.harvard.edu/daily/negotiation-skills-daily/the-drawbacks-of-goals/

2021-04-16T22:40:21Z

Create page. Source: Harvard webpage https://www.pon.harvard.edu/daily/negotiation-skills-daily/the-drawbacks-of-goals/

New page

''Behavioural skills - cognitive bias''.

The anchoring effect, or ''anchoring bias'', is a tendency in decision-making to place excessive importance on the first piece of information accessed.

This intial piece of information is known as the ''anchor''.

A common example is the first figure mentioned in a price negotiation.

The reasonableness, or acceptability, of subsequent figures tends - wrongly - to be evaluated by reference to the earlier figure, rather than by objective criteria.

== See also ==
* [[Affinity bias]]
* [[Bandwagon bias]]
* [[Behavioural economics]]
* [[Behavioural skills]]
* [[Choice supporting bias]]
* [[Cognitive bias]]
* [[Confirmation bias]]
* [[Default bias]]
* [[Diversity]]
* [[Dunning-Kruger effect]]
* [[Emotional intelligence]]
* [[Executive coaching]]
* [[Hindsight bias]]
* [[Impostor syndrome]]
* [[Maslow's hammer]]
* [[Objectivity]]
* [[Optimism bias]]
* [[Reactance bias]]
* [[Self-investment bias]]
* [[Self serving bias]]
* [[Social bias]]
* [[Source bias]]
* [[Status quo bias]]
* [[Working effectively with others]]

[[Category:Commercial_drive_and_organisation]]
[[Category:Influencing]]
[[Category:Self_management_and_accountability]]
[[Category:Working_effectively_with_others]]
[[Category:Financial_management]]
[[Category:Knowledge_and_information_management]]
[[Category:The_business_context]]